# 2 if statement in one cell

#### kelvin_9

##### Active Member
`=IF(OR(C51="*",C51=""),IF(ISNUMBER(MATCH(C\$49,INDEX(RDO!\$A\$2:\$M\$100,,MATCH('RESULT-1'!\$B51,RDO!\$A\$1:\$M\$1,0)),0)),"RDO",""),IF(ISNUMBER(MATCH(C\$49,INDEX(RDO!\$A\$2:\$M\$100,,MATCH('RESULT-1'!\$B51,RDO!\$A\$1:\$M\$1,0)),0)),"wrong",C51))`

`=IF(C51="00:00 - 00:00",VLOOKUP(\$A51,'SCHEDULE-1'!\$A:\$I,3,FALSE),"")`

can this 2 if statement be used in one cell like cell D51?

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

#### DanteAmor

##### Well-known Member
Try this

=IF(OR(C51="*",C51=""),IF(ISNUMBER(MATCH(C\$49,INDEX(RDO!\$A\$2:\$M\$100,,MATCH('RESULT-1'!\$B51,RDO!\$A\$1:\$M\$1,0)),0)),"RDO",""),IF(ISNUMBER(MATCH(C\$49,INDEX(RDO!\$A\$2:\$M\$100,,MATCH('RESULT-1'!\$B51,RDO!\$A\$1:\$M\$1,0)),0)),"wrong",IF(C51="00:00 - 00:00",VLOOKUP(\$A51,'SCHEDULE-1'!\$A:\$I,3,FALSE),C51)))

#### snjpverma

##### Well-known Member
I am guessing what does the first part of the formula does? I believe it's giving a "yes" if is some data in cell due to asterisk ( * ) and also giving a yes if it is blank due to the quotes ( "" )..
Let me know the concept if I am thinking wrong.

`OR(C51="*",C51="") `

#### kelvin_9

##### Active Member
Try this

=IF(OR(C51="*",C51=""),IF(ISNUMBER(MATCH(C\$49,INDEX(RDO!\$A\$2:\$M\$100,,MATCH('RESULT-1'!\$B51,RDO!\$A\$1:\$M\$1,0)),0)),"RDO",""),IF(ISNUMBER(MATCH(C\$49,INDEX(RDO!\$A\$2:\$M\$100,,MATCH('RESULT-1'!\$B51,RDO!\$A\$1:\$M\$1,0)),0)),"wrong",IF(C51="00:00 - 00:00",VLOOKUP(\$A51,'SCHEDULE-1'!\$A:\$I,3,FALSE),C51)))
thank you so much for the prompt reply
Its working just prefect
All master here are saving my life like jesus

#### kelvin_9

##### Active Member
I am guessing what does the first part of the formula does? I believe it's giving a "yes" if is some data in cell due to asterisk ( * ) and also giving a yes if it is blank due to the quotes ( "" )..
Let me know the concept if I am thinking wrong.

`OR(C51="*",C51="") `
the formula I am using is to return
When blank cell, it might employee’s RDO(rotation day off) with a table and if their criteria(RDO# & date) are met
you may refer to another post here, you will find what I am talking then

Replies
4
Views
220
Replies
1
Views
152
Replies
1
Views
214
Replies
3
Views
217
Replies
9
Views
222

1,130,030
Messages
5,639,635
Members
417,101
Latest member
amoverton2

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