SOLVED

New Contributor

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 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 (New Contributor)
Solution

Re: formulas for returning values if another cell is blank

Use:

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

Re: formulas for returning values if another cell is blank

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, "")

Re: formulas for returning values if another cell is blank

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

-jstromb

Re: formulas for returning values if another cell is blank

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