|I get 1500.003 on my calculator and in Excel - using your exact numbers, manually entered.|
How are your values getting into B27 and B59? Are they manually entered or are they a result of formulas? Depending on the format of the cell, you may see a certain number, but that may not be the number that Excel is using.
For example, if your 90% is the result of a calculation and the cell is formatted to only show 2 digits, it may display 90%, but may actually be a different number
90.4972% * 1666.67 = 1508.29, but 90.4972% will be displayed as 90% if the cell is formatted to not display the decimal places.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03