Conditional formatting Solved/Closed

Question

can any one help me i have following situation  and i drag the formula down , i do not want to show the result in c2 because there are no data in it(blank cells), i do not want to show "no veriance " with blank cell, i  have used excel if fuction

a1                     b1                       c1
10                     100                  variance                         =if(a1=ba,"no veriance","veriance")
blank cell         blank cell        no veriance
blank cell         blank cell        no veriance
blank cell         blank cell        no veriance
blank cell         blank cell        no veriance
blank cell         blank cell        no veriance

rizvisa1 · Answer

Try this

this is for if both should not be blank

=IF(AND(A1="", B1=""), "", if(a1=b1,"no veriance","veriance") )

sandy · Answer

resolved my querry

Conditional formatting

2 responses

Similar discussions

Subscribe To Our Newsletter!