CODEWITHSUNDEEP
vbaexcelexcel-formulaexcel-2010
Deepak
Deepak

Reputation: 473

How to avoid Blank cells when using IF Formula in Excel

enter image description here

I have a Table and in column D i will enter this formula. 

=IF(AND(A2<=(TODAY()+90);C2<=40%);"High";"Low")

I will insert inside a Table. So it can be automatically draged down. Based on conditions, it will show High or Low and then it will highlight only the entire row for "High". But my problem is if there is no values in Column C; then it is still showing as High and Highlighting. If there is no value then it should not show anything. How to change the formula. Help me

Upvotes: 0

Views: 57

Answers (2)

Moosli
Moosli

Reputation: 3285

If you are useing a Table inside A Table i would Work With @. and a Second if Condition.

=If([@Complete]="";"";IF(AND([@Date]<=(TODAY()+90);@Complete<=40%);"High";"Low")

Upvotes: 1

MarcinSzaleniec
MarcinSzaleniec

Reputation: 2256

add one more condition:

=IF(ISBLANK(C2);"";IF(AND(A2<=(TODAY()+90);C2<=40%);"High";"Low"))

Upvotes: 2

Related Questions