Apr 19 2023 04:58 AM
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!
Apr 19 2023 05:07 AM
In F64:
=IF(E64=""; ""; ROUND(ABS(D64-E64; 2)))
In G64:
=IF(F64=""; ""; ROUND(F64+$J$45; 2))
Apr 19 2023 06:21 AM