Percentage Calculation

[Bill Neilsen]

I have 6 fields in the table Labour1, Rate1, Labour2, Rate2, Freight,
ExtraCosts, GST.
The GST to be calculated is 10% the formula I have written for the total is
([Labour1]*[Rate1])+([Labour2]*[Rate2])+[Freight]+[ExtraCosts]
But how do I finish it off to calculate 10% of the total

Can anyone help please

 

[tina]

(([Labour1]*[Rate1])+([Labour2]*[Rate2])+[Freight]+[ExtraCosts])*.1

hth

 

[G. Vaught]

Encapsulate the entire formula into additional parentheses and then type
*.10 at the end. This will give you 10% of the total. If you want the 10%
included in the total, then type * 1.1, which will give you 100% plus 10%.

 

[Bill Neilsen]

Thanks to both of you, it works a treat.

Sometimes the solutions are so simple that you can't see them staring you in
the face.

Encapsulate the entire formula into additional parentheses and then type
*.10 at the end. This will give you 10% of the total. If you want the 10%
included in the total, then type * 1.1, which will give you 100% plus 10%.

I have 6 fields in the table Labour1, Rate1, Labour2, Rate2, Freight,
ExtraCosts, GST.
The GST to be calculated is 10% the formula I have written for the total
is
([Labour1]*[Rate1])+([Labour2]*[Rate2])+[Freight]+[ExtraCosts]
But how do I finish it off to calculate 10% of the total

Can anyone help please