Forum Discussion

malaba13's avatar
malaba13
Copper Contributor
Apr 18, 2019

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 l...
excel
Excel Online
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 18, 2019

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

 

  • malaba13's avatar
    malaba13
    Copper Contributor
    Apr 19, 2019
    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.

Resources