View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael Michael is offline
external usenet poster
 
Posts: 791
Default Calculation Formula

=round((A1*B1),0)
Assuming you have the variables in a1 and b1
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Judy@GMB" wrote:

Whats the formula for multiplying a dollar amount by a % to get a whole,
rounded $ amount? My result is sometimes off by $.01.
--
JLS