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 eliminate this? Thank you!
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)),"")

3 Replies

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