Calculation Formula

[Judy@GMB]

What’s the formula for multiplying a dollar amount by a % to get a whole,
rounded $ amount? My result is sometimes off by $.01.

 

[Michael]

=round((A1*B1),0)
Assuming you have the variables in a1 and b1

 

[Shane Devenshire]

Hi,

=ROUND(A1*B1,0)

where A1 is the dollar amount and B1 is the percent. You did say whole $
amount, no pennies?

=ROUND(A1*B1,2)

would round to the nearest penny.

If this helps, please click the Yes button,

Cheers,
Shane Devenshire

 

[T. Valko]

Maybe this:

A1 = some dollar amount
B1 = some percentage (like 5%)

=ROUND(A1*B1,2)