Forum Discussion
Help with Excel and IF Statements
I have a spreadsheet and I am trying to add a IF Statement to work out if commissions are underpaid or Ok. The IF statement works in the first cell, however, once I copy down formula it doesn't always provide accurate response (highlighted in red in attached spreadsheet).
Martine,
In fact, the result of the formula is correct!
The values in column D have hidden decimals!
Select one of these cells and press Increase Decimal Button several times to see these decimals as shown the below screenshot.
To get rid of these decimals use this formula in cell D2 and copy it down:
=ROUND(C2/31*365/B2,5)
Martine,
In fact, the result of the formula is correct!
The values in column D have hidden decimals!
Select one of these cells and press Increase Decimal Button several times to see these decimals as shown the below screenshot.
To get rid of these decimals use this formula in cell D2 and copy it down:
=ROUND(C2/31*365/B2,5)
Thank you, now working perfectly.
