Forum Discussion

Gambo's avatar
Gambo
Copper Contributor
Jan 08, 2026
Solved

Excel ignoring part of formula

=IF(F3="","",IF(F3-G3=0.01,1,IF(F3>G3,3,IF(F3=G3,1,IF(F3<G3,0))))) My cells F3 & G3 refer to a match score, with the Result showing (in Cell AM3) being 3pts for a win, 1 point for a Draw, and 0 for ...
excel
  • Gambo's avatar
    Gambo
    Jan 08, 2026

    Excellent! Thanks! After many attempts to solve it myself, <= makes the difference. Will also try the <=0.011 to see if that helps.

     

    Thanks once again!😁👍

Resources