I have the following that I would like to round off the number
=([PRICE]+([PRICE]*0.075+840))/0.47/0.88+750
I have the following that I would like to round off the number
=([PRICE]+([PRICE]*0.075+840))/0.47/0.88+750
Perhaps: Round(([PRICE]+([PRICE]*0.075+840))/0.47/0.88+750,0)
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Be aware Round() uses banker's rule.
Round(5.45,1) = 5.4
Round(5.35,1) = 5.4
Round(5.46,1) = 5.5
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Round off the number?
To x digits/decimal places? To nearest integer?
An example might be helpful.
I substituted 100 for Price
?(100+(100 * 0.075 + 840))/0.47/0.88 + 750
3040.86073500967
What result would you like?
?fix((100+(100 * 0.075 + 840))/0.47/0.88 + 750 )
3040
Thank you very much I used the first reply it works great for what I need,