Handyman Wire

Who's Online
1 registered (RipCord), 132 Guests and 2 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.
Page 2 of 2 < 1 2
Topic Options
#910541 - 04/01/17 06:14 PM Re: Excel Programing Question [Re: Clint_Robbins]
dora Offline
Search and Rescue
Carpal Tunnel

Registered: 02/16/02
Posts: 22453
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!

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

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.

#919898 - 07/28/17 01:37 PM Re: Excel Programing Question [Re: Clint_Robbins]
JohnMillerMiller Offline
first timer

Registered: 07/28/17
Posts: 1
Loc: Chicago
Can I build 3D surfaces in MS EXCEL?
I study astronomy.This knowledge is only the first step of mankind into space. I use my knowledge, in writing the dissertations for Essayshark. I also plan to study in more detail how air pollution affects the human body

Page 2 of 2 < 1 2

Moderator:  CabinConnection, Ernie 

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