EXCEL CONDITIONAL PROBLEM =(IF,true,false)

Copper Contributor

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)

PROBLEMO.jpg

3 Replies

@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

 

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.

@malaba13 , you are welcome