I have the following that I would like to round off the number
=([PRICE]+([PRICE]*0.075+840))/0.47/0.88+750
Rounding off a number in a text box
Competent Performer
Windows 8 
Access 2013
I have the following that I would like to round off the number
=([PRICE]+([PRICE]*0.075+840))/0.47/0.88+750
Access Developer
Windows 7 32bit Access 2013
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
VIP
Windows 10 Access 2010 32bit
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.
Moderator
Windows 10 Access 2010 32bit
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
Competent Performer
Windows 8 Access 2013
Thank you very much I used the first reply it works great for what I need,
Fixing #Num! error and rounding when Inserting text box with formula
Rounding a number in a query
Rounding number up to half hour
Posting Permissions
Reply With Quote