Forum Discussion

Copper Contributor

Jul 01, 2021

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

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

Thank you!!

excel

Formulas and Functions

HansVogelaar
Jul 01, 2021
jstromb

Use:

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

4 Replies

PeterBartholomew1
Silver Contributor
Jul 01, 2021
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, "")
- jstromb
  Copper Contributor
  Jul 02, 2021
  Peter, thank you so much for your quick response! I really appreciate your help!!
  have a great weekend!! Happy 4th!!
  jstromb
HansVogelaar
MVP
Jul 01, 2021
jstromb

Use:

=IF(D44="","",F44*24*D$1)
- jstromb
  Copper Contributor
  Jul 02, 2021
  HansVogelaar , thank you so much! this worked beautifully and is so simple! I appreciate your quick reply!
  -jstromb