Oct 03 2022 05:42 AM
My formula gives me a value that is off by .01.
For example:
value of (bf12) = 1222.82(-)
value of bfe13) = 1020.00
but my formula gives me a value of 202.81 (s/b) 202.81
What is wrong with the math? formula?
Oct 03 2022 06:02 AM
Oct 03 2022 06:15 AM
Set the number format of all cells involved to Number with 15 decimal places. Are the numbers you see then exactly equal to 1222.82 and 1020.00?