IF function with 2 conditions

[gjrr4x1]

Hi everyone,

I'd like some help with an if function that returns OK (Assume cell A1) if the value in C5 is greater than the value in B5 OR the value in C5 is equal to zero and ERROR otherwise (A2).


I tried:

=IF(OR(C5>B5;-0,1<C5<0,1;A1;A2)

But it doesn't work.

I can't upload a book with the example, there must be something wrong with my IE :S

Thanks in advance!

[Fotis1991]

=IF(OR(B5<C5,C5=0),"ok","error") ?????????

[Ranulor]

Based on your formula, I'd say you made a mistake on the parenthesis,
It should be something like :

=IF(OR(C5>B5;C5=0);A1;A2)

Hope it helps

[gjrr4x1]

Works.


Damn was that simple.


Much appreciated Fotis!