Rounded Numbers Not Equal

[artiststevens]

Hello,
Can somebody help me with formatting decimals? I use the number format in Excel to format decimals with 5 places. When I round them down to 4 places and attempt to find the equal sums, some are not recognized.

Example:
A1: 1.34458 = Rounded 1.3460
B1: 1.34460 = Rounded 1.3460
C1: =A1<=B1 (Not equal using number format.)

Thank you in advance for any and all help.

[DonkeyOte]

A Number Format affects only the appearance of a value never it's underlying value.

Given calculations are based on the underlying values [unless using Precision as Displayed: invariably a bad idea] altering Formats has no effect on your formula.

Please Login or Register  to view this content.

[artiststevens]

DonkeyOte,
Thanks for the help and that bit of knowledge I never knew that about number format. Thanks again.