Results 1 to 2 of 2

Thread: Formula not giving correct output

  1. #1

    Formula not giving correct output



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    I have a fomula field in row 67 and 68 .Row 67 calculates the average and row 68 calculates the improvement i.e. average(row 68)- last row inserted(row 67). The values for improvements are not showing correct value. C68 seems to give correct value but B68 and D68 is giving wrong value.

    B68=4.8-4.5 =0.3 but it shows 0.4
    C68=14.9-15.1=-0.2
    D68=11.3-10.2=1.1 but it shows 1.0

    I am confused, let me know if any clues.

    I have attached the sheet also.

    Sheet 1.xlsx

    Thanks in Advance .

    Regards,
    A.A.K.

  2. #2
    Quote Originally Posted by aakhan2011 View Post
    Hi All,

    I have a fomula field in row 67 and 68 .Row 67 calculates the average and row 68 calculates the improvement i.e. average(row 68)- last row inserted(row 67). The values for improvements are not showing correct value. C68 seems to give correct value but B68 and D68 is giving wrong value.

    B68=4.8-4.5 =0.3 but it shows 0.4
    C68=14.9-15.1=-0.2
    D68=11.3-10.2=1.1 but it shows 1.0

    I am confused, let me know if any clues.

    I have attached the sheet also.

    Sheet 1.xlsx

    Thanks in Advance .

    Regards,
    A.A.K.
    The results shown are correct. B66 is 4.48 (unrounded figure) and B67 is 4.84. The difference is 0.36 which is rounded to 0.4. Same applies to D68.
    This is caused by the rounding of numbers.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •