ok my problem is when I do my equation with my data on a calculator example 1666.67*90%=1500.003

but if i do the formula =IF(AND($B$59<100%,$B$59>75%),$B$59*$B$27,"") i get 1508.29 (B59=90% and B27 = 1666.67)

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

Awesome that was my problem!!!! tytytytytytytytyty!!!!!!

Ask Your Question

Weekly Poll

Would you use Amazon to buy airline tickets?

Discuss in The Lounge

Poll History