rounding formula
 

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

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

rounding formula
 

qmaster

Have a look at the Dollar and Round commands

eg
a1 has 33 in it

a2 =DOLLAR(A1/4,0)
a3 =ROUND(A4/4,0)

Both Result = $8

Sum command does not appear to work with Dollar command but does work
with Round command


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=397095

rounding formula
 

Sum doesn't work with Dollar as Dollar converts result to text.

Hope this helps
Rowan

"mudraker" wrote:


qmaster

Have a look at the Dollar and Round commands

eg
a1 has 33 in it

a2 =DOLLAR(A1/4,0)
a3 =ROUND(A4/4,0)

Both Result = $8

Sum command does not appear to work with Dollar command but does work
with Round command


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=397095