Forum Discussion
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 for...
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))