Formula with 3 contingencies

sburkhar

Active Member
Joined
Oct 4, 2006
Messages
363
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?
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

sburkhar

Active Member
Joined
Oct 4, 2006
Messages
363
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

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Put spaces around your less than signs. Is it?

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

jim may

Well-known Member
Joined
Jul 4, 2004
Messages
7,480

ADVERTISEMENT

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

Active Member
Joined
Oct 4, 2006
Messages
363
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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092

ADVERTISEMENT

Look at my post and try the formula there.
 

sburkhar

Active Member
Joined
Oct 4, 2006
Messages
363
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.
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,881
Hi

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

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

this will display as

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


Try this way.


Also did you try Andrew's formula?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,577
Messages
5,596,996
Members
414,116
Latest member
sfullnet

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top