View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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