Calculation Formula
Maybe this:
A1 = some dollar amount
B1 = some percentage (like 5%)
=ROUND(A1*B1,2)
--
Biff
Microsoft Excel MVP
"Judy@GMB" wrote in message
...
What's the formula for multiplying a dollar amount by a % to get a whole,
rounded $ amount? My result is sometimes off by $.01.
--
JLS
|