help with IF function returning a false result instead of a true result

[Souled]

basically i want the function to return a TRUE value result instead of a false one based on these numbers

the formula i want to calculate is:

price * quantity - actual price = discount price

as you can see in the file i uploaded a one line example that the formula is true but it gives a false statement.

thank you for your help

[Pete_UK]

If you increase the number of decimals in cell F2, you will see that the calculation actually results in 0.699999 etc. As your Discount column (D) is only 1 decimal place, you can use ROUND in your formula to get it to show correctly, i.e.:

=IF(ROUND(A2*B2-C2,1)=D2,"yes","no")

Hope this helps.

Pete

[Souled]

yeah it solved my problem
thank you very much
but i don't understand i wrote the numbers down (not copy pasted) so why 14-13.3=0.699999999?

[Pete_UK]

It is because the number 13.3 cannot be expressed with complete accuracy using binary numbers, which most computers use. Although some (decimal) fractions can be translated completely into binary, some other common fractions cannot - for example 0.1 (or 1/10) will be a recurring fraction in binary, as will 0.3 (or 3/10), in the same way as 1/3 cannot be expressed completely in the decimal numbering system, no matter how many digits are used. Thus you might say that 1/3 is 0.3333 in decimal, but you will find that 0.3333 + 0.3333 + 0.3333 does not equal 1. The same thing is happening here with your numbers.

Hope this helps.

Pete

[Pete_UK]

Glad to help - thanks for the rep.

Pete