TextBox Calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've set up a conditional formula in a TextBox control source to calculate
sales tax for my local area .

=IIf([State]="AR",([Parts]+[Labor]+[Misc])*0.0925,0)

The problem is this leaves left-over 1/2 pennies in the Ballance Due field
even if the balance is paid in full. How do I get this to calculate to only 2
decimal places?
 
Hi Rick,

Try this:

=round(IIf([State]="AR",([Parts]+[Labor]+[Misc])*0.0925,0), 2)

Hope this helps.

Damian.
 
This might work. The values round down. In other words, 1.5 becomes 1. It's
not exactly acurate but it leaves no balance due.

Thanks,
Rick

Damian S said:
Hi Rick,

Try this:

=round(IIf([State]="AR",([Parts]+[Labor]+[Misc])*0.0925,0), 2)

Hope this helps.

Damian.

Rick said:
I've set up a conditional formula in a TextBox control source to calculate
sales tax for my local area .

=IIf([State]="AR",([Parts]+[Labor]+[Misc])*0.0925,0)

The problem is this leaves left-over 1/2 pennies in the Ballance Due field
even if the balance is paid in full. How do I get this to calculate to only 2
decimal places?
Click to expand...
Click to expand...
 
Back
Top