IF OR formula

[audrey]

Hello,

I am trying to make a simple IF OR formula, but for some reason it doesnt seem to work....

=IF(OR(N60="N/A", M60="N/A", N60-M60<0,"",N60-M60)


so basically in those 3 cases I want the formula to leave a blank, if non of those cases are realized I want the formula to perfom a basic substraction.

I think I can also use IF(ISNUMBER formula??? If n60 or M60 is not an actual number leave blank or perfom a basic substraction.....


Thanks!

 

[cgcamal]

Hi Audrey,

It seems a parentheses is missing.

=IF(OR(N60="N/A", M60="N/A", N60-M60<0[B][COLOR=Red])[/COLOR][/B],"",N60-M60)

Regards

 

[audrey]

Hello Cgcamal, It s not it. I am still getting VALUE error

 

[Marcelo Branco]

Maybe this
=IF(OR(ISNA(N60),ISNA(M60)),"",IF(N60-M60<0,"",N60-M60))

M.

 

[audrey]

Hello Marcelo,

the formula you have written should have worked but for some reason I still get this error

 

[Michael M]

Try and stick to the one thread
duplicate posted here
http://www.mrexcel.com/forum/showthread.php?t=548016

 

[Marcelo Branco]

It worked for me, unless i have a text in one cell, not a number. Check it, please.

M.

 

[JB_Scotland]

Marco, Audrey's N/As are text values. See my solution on the other thread.