Forum Discussion

Patrick_Carr1650's avatar
Patrick_Carr1650
Copper Contributor
Sep 01, 2023

Excel Formula Help

Good Afternoon,

 

I am trying to hide my formula if a certain cell is blank. Currently my formula is doing what I want but auto populates “0-Jan-00” when I drag the formula down the column. The formula is =IF(OR(N6=“Undeliverable”, N6=“No Response”), M6+45, N6). This formula is placed within cell Q6.  My end goal is if cell N6 is blank, then I want Q6 to be blank. If there is a value of “Undeliverable”, “No Response”, or a date in N6 then I want Q6 to run the above formula.

 

The above formula currently works when I place one of the three data values in column N, but I don’t want it to present a value if column N is blank.

 

Thank you in advance for any and all help!

admin
developer
excel
Formulas and Functions
office 365
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Sep 01, 2023

    Patrick_Carr1650 You can't have the formula present or not based on a condition, but you can use another IF to display an empty string if N6 is blank/empty. If N6 is not empty it will perform the calculation or your original formula.

    =IF(ISBLANK(N6),"",IF(OR(N6="Undeliverable", N6="No Response"), M6+45, N6))

Resources