View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mangesh Yadav[_4_] Mangesh Yadav[_4_] is offline
external usenet poster
 
Posts: 101
Default rounding formula

Lets say your value is in cell A1 and the percent figure in cell B1, then
use

=ROUND(A1*B1,0)


Mangesh




"qmaster" wrote in
message ...

I am looking for a formula that will allow me to compute a percentage of
value A and round the result to the neareast whole dollar. Any
assistance is greatly appreciated


--
qmaster
------------------------------------------------------------------------
qmaster's Profile:

http://www.excelforum.com/member.php...o&userid=26439
View this thread: http://www.excelforum.com/showthread...hreadid=397095