rounding formula

[qmaster]

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

[mudraker]

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

[Mangesh Yadav]

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

=ROUND(A1*B1,0)


Mangesh




"qmaster" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Rowan]

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
>
>