IF and OR nested function

J

Jon M

I need to test a cell to see if the cell is blank or if the value is < 0.
Trying:

=IF((OR(A2="",A2<0),1,0)) should return 1 if it is blank or less than 0 and
0 if cell contains a value > 0.

Keep getting an error.

Can you tell me where I am going wrong?

Thanks,
 
M

Mike H

Hi,

It was a parenthesis problem

=IF(OR(A2="",A2<0),1,0)

or to take care of text

=IF(OR(A2="",ISNUMBER(A2<0)),1,0)

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Nested IF Function 2
Nested IF function 3
Excel Need Countifs Formula Help 0
solving nested IF statements 13
nested if 5
I need a formula for if cells a1 and a2 are the same then cell a3 3
Why doesn't writing a nested IF function work? 1

Top