Ask a question Report Reply to this topic

Negative cells [Solved/Closed]

whatsit - Aug 23, 2016 at 12:41 AM - Latest reply: Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen

- Aug 24, 2016 at 08:50 AM

Excel Ask a question Report Reply to this topic

Hello, Please would someone help me with what I think is a simple problem.
I have a range of cells which decrease in value and some become positive numbers and some are negative numbers. The numbers in these cells vary depending upon the formula used from another cell. They can be negative or positive depending on the formula. What I wish is for a formula that can put "n/a" in the negative cells instead of the negative number. I appreciate any help you can give. Thank you.

Negative cells
Excel make cell flash red (Solved) » Forum - Excel
Find location using cell phone number » How-To - Mobile
If cell contains any text (Solved) » Forum - Excel
Create gmail account on my cell phone (Solved) » Forum - Gmail
Excel conditional formatting based on date in another cell » How-To - Excel

3 replies

Report Respond to Mazzaropi

Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Aug 23, 2016 at 11:35 AM

Helpful

whatsit, Good morning.

Suppose:
A1 --> 10
B1 --> 20

Try to use it:
C1 --> =IF(A1-B1<0, NA(), A1-B1)

Is this what you want?
I hope it help.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Report Respond to whatsit

whatsit - Aug 23, 2016 at 11:50 PM

Helpful

hello Mazzaropi
Thank you for responding. Your formula worked and I am grateful for your help. I find all volunteers on this forum very helpful .

Report Respond to Mazzaropi

Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Aug 24, 2016 at 08:50 AM

Helpful

whatsit, Good morning.

Thank you for the feedback.
Have a nice day.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Ask a question