Conditional formatting

Solved/Closed
sandy - Apr 29, 2010 at 08:39 AM
 sandy - Apr 30, 2010 at 01:04 AM
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

2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Apr 29, 2010 at 08:46 AM
Try this

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