SOLVED

formulas for returning values if another cell is blank

Copper Contributor

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 value in G44: (F44*24)*D$1. 

 

I'm not sure if I can use IF with ISBLANK....

Thank you!!

4 Replies
best response confirmed by jstromb (Copper Contributor)
Solution

@jstromb 

Use:

=IF(D44="","",F44*24*D$1)
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, "")

@Hans Vogelaar , thank you so much! this worked beautifully and is so simple!  I appreciate your quick reply!

-jstromb

Peter, thank you so much for your quick response! I really appreciate your help!!
have a great weekend!! Happy 4th!!
jstromb
1 best response

Accepted Solutions
best response confirmed by jstromb (Copper Contributor)
Solution

@jstromb 

Use:

=IF(D44="","",F44*24*D$1)

View solution in original post