Formula with 3 contingencies

[sburkhar]

I have written formula =IF(OR(Z10>=H10,X10<O10),"X","") But I need the further contingency that if Z10 is empty I need I10 to remain empty rather than place the X.

Can you help?

 

[sburkhar]

It doesn't look like my entire message posted. I wrote:

I have written =IF(OR(Z10>=H10,X10<O10),"X","") I need the further contingency that if Z10 is empty, I10 needs to remain empty rather than placing the X in the cell.

 

[Jonmo1]

try putting spaces before and after < and >
Sometimes the board software thinks they are HTML Tags...

Also, try code tags

"["code"]"
formula here
"["/code"]"

Without the quotes..

 

[Andrew Poulsom]

Put spaces around your less than signs. Is it?

=IF(OR(Z10>=H10,X10 < O10),IF(Z10="","","X"),"")

 

[jim may]

Your formula is incomplete.
The If Statement requires ( a minimum of 2 arguments)
If TRUE, THEN (with optional 3rd , ELSE)
The OR Statement can have numerous arguments like
OR(Arg!, Arg2, Arg3, Arg4) << with this syntax

 

[sburkhar]

why isn't my entire message showing?

Formula: =IF(OR(Z10>=H10,X10<O10),X,"")

I need the further contingency that if Z10 is empty then I10 needs to remain empty rather than placing the X.

 

[Andrew Poulsom]

Look at my post and try the formula there.

 

[sburkhar]

let me try it this way.
My statement as written works fine and places the X in cell I10. However I need a third argument that if cell Z10 is empty then I10 also needs to remain empty rather than placing the X.

I don't know how to write 3 arguments.

 

[Andrew Poulsom]

Did you try the formula I posted?

 

[pgc01]

Hi

Jonmo explained how to post the formula, using the code tags:

=IF(OR(Z10>=H10,X10<O10),"X","")

this will display as

=IF(OR(Z10>=H10,X10<O10),"X","")

Try this way.


Also did you try Andrew's formula?