# Negative cells [Solved/Closed]

whatsit - Aug 23, 2016 at 12:41 AM - Latest reply: Mazzaropi 1793 Posts Monday August 16, 2010Registration dateContributorStatus March 19, 2018 Last seen - Aug 24, 2016 at 08:50 AM
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

## 3 replies

Mazzaropi 1793 Posts Monday August 16, 2010Registration dateContributorStatus March 19, 2018 Last seen -
0
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
whatsit -
0