Nested If Statment

[n18]

Hi,

I have a 'if statement' that works

=IF(B2>=C2,"Yes","No")

What I need to do is is put another if in this,
so if the cell is not blank then do the above formula.

Any idea how to do this in one statement?

Thanks

 

[VoG]

Try

=IF(OR(B2="",C2=""),"",IF(B2>=C2,"Yes","No"))

 

[n18]

Thanks for getting back to me, I am still getting the same result, so if one of B2 or C2 is blank or both I am still getting a value of Yes or No. I'm hoping to get a result of blank.

It should only return a value of yes or no if both B2 and C2 are populated. I'm basically seeing if one date is greater than the other, if it is then 'No' otherwise it's 'Yes'.

Thanks for the help

 

[VoG]

Working here

Excel Workbook
	B	C	D
2	1
3		4
4
5	1	2	No
6	8	4	Yes
Sheet3

 

[n18]

Thanks, must be something to do with my sheet, the date cells, B2 and C2 etc, are coming form a linked sheet so that might be something to do with it. Thanks anyway for the help

 

[VoG]

Maybe they contain a space instead of being blank. In that case

=IF(OR(B2=" ",C2=" "),"",IF(B2>=C2,"Yes","No"))

 

[n18]

Thanks again, just removed the link between the sheets and it worked, no idea why it doesn't work with the link because the cells are still populated with the same values, i.e. blank or a date. Have to do a bit of research and see