Previous Topic Next Topic

Negative cells

Solved/Closed
whatsit - Aug 23, 2016 at 12:41 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 - 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.



3 replies

Answer 1 / 3
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 147
Aug 23, 2016 at 11:35 AM
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
0
Answer 2 / 3
whatsit
Aug 23, 2016 at 11:50 PM
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 .
0
Answer 3 / 3
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 147
Aug 24, 2016 at 08:50 AM
whatsit, Good morning.

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