Report

Negative cells [Solved]

Ask a question whatsit - Last answered on Aug 24, 2016 08:50AM
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.
See more 
Helpful
+0
moins plus
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
Add comment
Helpful
+0
moins plus
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 .
Add comment
Helpful
+0
moins plus
whatsit, Good morning.

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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!