Forum Discussion
Wrong data returning
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.
Please HELP, it's driving me up the walls!!
Thanks!
2 Replies
In F64:
=IF(E64=""; ""; ROUND(ABS(D64-E64; 2)))
In G64:
=IF(F64=""; ""; ROUND(F64+$J$45; 2))
