Handyman Wire

Who's Online
3 registered (AnthraciteSparky, 2 invisible), 188 Guests and 4 Spiders online.
Key: Admin, Global Mod, Mod
Welcome Newcomers
Unregistered users may only post in the handyman forum. If you register, you may post in any forum and use of CAPTCHA code is not required.
Advertisement
Page 2 of 2 < 1 2
Topic Options
#910541 - 04/01/17 07:14 PM Re: Excel Programing Question [Re: Clint_Robbins]
dora Offline
Search and Rescue
Carpal Tunnel

Registered: 02/16/02
Posts: 22235
Loc: Somewhere under the sun
On this link using the step Method 3:Using ABS may work for you.
_________________________
Life is about using the whole box of crayons!

Top
#919058 - 07/17/17 04:52 AM Re: Excel Programing Question [Re: Clint_Robbins]
joemiller Offline
newbie

Registered: 07/14/17
Posts: 6
Loc: Arizona, USA
1. Enter the numbers as usual, after finishing all entries, do the following:
2. Go to any other empty cell, and type '-1' and copy it, now select the entire column you want to make negative.
3. Right-click on the selection and select 'Paste Special..'
4. Choose 'All' and 'Multiply' and click OK, as shown in the picture below: Now all the selected cells will be negative. Now delete the cell value '-1' you copied from.

Or you can use VBA. I often use the first method to perform tasks for https://assignment.essayshark.com/finance-help.html. For me it is simpler and more understandable, besides, I'm already used to this action.

Top
Page 2 of 2 < 1 2

Moderator:  CabinConnection, Ernie 


Experts | Email Us | Disclaimer | HandymanWire home
Articles | We welcome your feedback.| Privacy
http://www.handymanwire.com
Handyman Wire
your resource for advice on home improvement and repairs.
Copyright ©1999-2016, Handyman USA LLC.
All rights reserved.