Apr 18 2019 11:34 AM
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)
Apr 18 2019 11:39 AM
@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
Apr 19 2019 02:05 AM