IF function

[gurj_sandhu]

I have an If formula which displays a certain word if the value of the cell next to it is greater than equal to another cell. How can i add another reference to say if the cell is blank then show a blank cell.

my If formula is as follows:

=IF($G4>$A$2,"OUTSTANDING","OVERDUE")

i want the cell to return a blank value if the cell reference G4 is blank.

Can anyone help?

Thanks in advance

 

[VoG]

Try

=IF($G4="","",IF($G4>$A$2,"OUTSTANDING","OVERDUE"))

 

[gurj_sandhu]

excellent VoG, thats done the trick.....