Excel Formula Help Needed Again

User avatar
hlewton
PlatinumLounger
Posts: 3808
Joined: 24 Oct 2010, 23:39
Location: Canton, Ohio USA

Excel Formula Help Needed Again

Post by hlewton »

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
Regards,
hlewton

User avatar
HansV
Administrator
Posts: 78393
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel Formula Help Needed Again

Post by HansV »

=IF(D10<0, -40*D10, "")
Best wishes,
Hans

User avatar
hlewton
PlatinumLounger
Posts: 3808
Joined: 24 Oct 2010, 23:39
Location: Canton, Ohio USA

Re: Excel Formula Help Needed Again

Post by hlewton »

HansV wrote:
28 Mar 2023, 12:43
=IF(D10<0, -40*D10, "")
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