Forum Discussion
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
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
