# Formula with 3 contingencies

#### sburkhar

##### Active Member
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?

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

#### sburkhar

##### Active Member
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
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
Put spaces around your less than signs. Is it?

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

#### jim may

##### Well-known Member

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
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

Look at my post and try the formula there.

#### sburkhar

##### Active Member
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

##### MrExcel MVP
Did you try the formula I posted?

#### pgc01

##### MrExcel MVP
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?

Replies
6
Views
225
Replies
5
Views
130
Replies
1
Views
217
Replies
10
Views
200
Replies
3
Views
350

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,517
Messages
5,832,217
Members
430,116
Latest member
d1pakjha

### 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.

### Which adblocker are you using?

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

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