gurj_sandhu
New Member
- Joined
- Oct 30, 2008
- Messages
- 30
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
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