Forum Discussion
Solved
formulas for returning values if another cell is blank
I am only working on one sheet and need a formula to display a value only if another cell has data in it: If D44 is empty (or blank), then G44 will be blank. Otherwise I want to return the following ...
It is valid but ISBLANK will only test for empty cells, not ones that have a formula that returns "". For that you could use
= IF( D44<>"", (F44*24)*D$1, "")
= IF( D44<>"", (F44*24)*D$1, "")
Peter, thank you so much for your quick response! I really appreciate your help!!
have a great weekend!! Happy 4th!!
jstromb
have a great weekend!! Happy 4th!!
jstromb