 Highlighted

# EXCEL CONDITIONAL PROBLEM =(IF,true,false)

I ve got a problem with the ecuacion =IF(condition; right; false)

If i write the condition as two cells are equal (A3=B3) as de condition for being true o false, if there are empty cells it counts like it compliments the condition so i get the right answer but i dont want this to happen i want to have an empty cell.

What can i do?

(**SI is IF in spanish)

PS (if i dont explain right the problem is that i dont want the 10 by deffect, i want empty space) 3 Replies

# Re: EXCEL CONDITIONAL PROBLEM =(IF,true,false)

@malaba13 , that could be

`=IF(ISBLANK(B1)*ISBLANK(C1),"",IF(B1=C1,10,-5))`

I attached the file, if open formula will be converted in your locale notation

Highlighted

# Re: EXCEL CONDITIONAL PROBLEM =(IF,true,false)

Thank you really much. It worked!!! I have no words, you are really a great man and you deserved the best in your life.
THANK YOU.
Highlighted

# Re: EXCEL CONDITIONAL PROBLEM =(IF,true,false)

@malaba13 , you are welcome