Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Rounding up and down formula | New Users to Excel | |||
rounding a formula in a cell, then replace the formula | Excel Programming | |||
rounding a formula in a cell, then replace the formula | Excel Programming |