I have a cell in Excel that will eventually equal a minus number. The cell is actually D10. Is there a formula I can place in another cell, maybe D50, that takes to minus number, whatever it may be, and multiply it by 40 and make that a positive number? For instance, if the minus number is 10, multiply it by 40 and have a positive number of 400 shown id cell D50. Also, can the cell be blank until cell D10 has a negative value in it?
Thanks
Excel Formula Help Needed Again
-
- PlatinumLounger
- Posts: 3808
- Joined: 24 Oct 2010, 23:39
- Location: Canton, Ohio USA
Excel Formula Help Needed Again
Regards,
hlewton
hlewton
-
- Administrator
- Posts: 78393
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- PlatinumLounger
- Posts: 3808
- Joined: 24 Oct 2010, 23:39
- Location: Canton, Ohio USA
Re: Excel Formula Help Needed Again
Awe, I believe that is multiplying 2 minuses to get a plus. I just have been away from doing math for toooooooo many years. Thank you.
Regards,
hlewton
hlewton