Forum Discussion

HB Energy's avatar
HB Energy
Copper Contributor
Mar 11, 2018
Solved

False in all blank cells with formula

I have a formula that is working properly, however all of the blank cells that contain the formula say “false” until the Corresponding cells used in the formula are filled. Is there anyway to eliminat...
Excel on Mac
Formulas & Functions
  • Jamil's avatar
    Jamil
    Mar 11, 2018
    Yes.

    just wrap formula inside another IF function

    =IF(A5<>"",IF(B5>B4,((B5-B4)*1.68)/(A5-A4)),"")
Jamil's avatar
Jamil
Bronze Contributor
Mar 11, 2018
Yes.

just wrap formula inside another IF function

=IF(A5<>"",IF(B5>B4,((B5-B4)*1.68)/(A5-A4)),"")
  • HB Energy's avatar
    HB Energy
    Copper Contributor
    Mar 11, 2018
    Great thank you very much!
    • Jamil's avatar
      Jamil
      Bronze Contributor
      Mar 11, 2018
      You are welcome.