G
Guest
I am trying to calculate a discount on an exchange rate (rate x .75%) but
when I do a manual calculation to verify the figures, some are rounding up or
down without rhymn or reason. Example:
Rate Manual Calc Excel Calc Should Be
1.8775 1.891581 1.8915 1.8916 (didn't round up)
1.2995 1.309246 1.3093 1.3092 (rounded up but shouldn't have)
I have formatted the cells and verified the correct number of decimals.
My exchange formula is: rate-(rate*discount)
Should I have to enter a rounding formula? I did create one and it worked
by itself but when I try to combine it with my exchange formula, it's not
working. I could have added the formula's incorrectly but am not sure how to
correct it.
The rounding formula is: If(rate>=5,1)*or(rate<5)
Thanks for any assistance that can be provided. Katherine
when I do a manual calculation to verify the figures, some are rounding up or
down without rhymn or reason. Example:
Rate Manual Calc Excel Calc Should Be
1.8775 1.891581 1.8915 1.8916 (didn't round up)
1.2995 1.309246 1.3093 1.3092 (rounded up but shouldn't have)
I have formatted the cells and verified the correct number of decimals.
My exchange formula is: rate-(rate*discount)
Should I have to enter a rounding formula? I did create one and it worked
by itself but when I try to combine it with my exchange formula, it's not
working. I could have added the formula's incorrectly but am not sure how to
correct it.
The rounding formula is: If(rate>=5,1)*or(rate<5)
Thanks for any assistance that can be provided. Katherine