Calculation Formula

J

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.
 
S

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

T. Valko

Maybe this:

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

=ROUND(A1*B1,2)
 
Top