Wrong data returning

Copper Contributor

Good afternoon, have been struggling with an issue, and it's driving me crazy!

Have this spreadsheet where I compare an input value (Column E), make an operation in (column F): =IF(E64="";"";ABS(D64-E64))) and then another in (Column G): =IF(F64=""; ""; (F64+$J$45)). Formulas work well, until I reach Input number 8. The formula in (Column J) is: =IF(E64=""; ""; IF(G64<=I64; "C"; "NC")). And although as you can see, the values from G64 and I64 are identical, if returns FALSE. If I input manually in  G64 the value 0.05 it works. I've checked that is number formatted, even using isnumber() function returns TRUE.

 

 

Rui_Soares_22_1-1681905072021.png

 

Please HELP, it's driving me up the walls!!

Thanks!

2 Replies

@Rui_Soares_22 

In F64:

=IF(E64=""; ""; ROUND(ABS(D64-E64; 2)))

In G64:

=IF(F64=""; ""; ROUND(F64+$J$45; 2))

@Hans Vogelaar My God!!! Thank you soooo much!!! :) :) 

 

Cheers!