| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Roud up or rond down
hey guy's, how do i write this formula? if a1=$6.80 round down to the nearest nine $6.79' if a1=$6.85 round up the nearest nine $6.89 thanks, jason -- jwfakouri ------------------------------------------------------------------------ jwfakouri's Profile: http://www.excelforum.com/member.php...o&userid=31435 View this thread: http://www.excelforum.com/showthread...hreadid=521288 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Roud up or rond down
Try =ROUND(A1+0.01,1)-0.01 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=521288 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Roud up or rond down
Hi
Just a quick "heads up", assuming the OP wants 6.84 to go down to 6.79, and it is only 6.85 and upward that needs to go up, then I think it needs to be .001 as the add-on, not .01 =ROUND(A1+0.001,1)-0.01 -- Regards Roger Govier "daddylonglegs" wrote in message news:daddylonglegs.24hd5y_1142038800.8848@excelfor um-nospam.com... Try =ROUND(A1+0.01,1)-0.01 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=521288 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Roud up or rond down
=ROUND(A15,0)-0.1
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "jwfakouri" wrote in message ... hey guy's, how do i write this formula? if a1=$6.80 round down to the nearest nine $6.79' if a1=$6.85 round up the nearest nine $6.89 thanks, jason -- jwfakouri ------------------------------------------------------------------------ jwfakouri's Profile: http://www.excelforum.com/member.php...o&userid=31435 View this thread: http://www.excelforum.com/showthread...hreadid=521288 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Roud up or rond down
Hi,
=ROUND(A1,1)-0.01 Regards, B. R. Ramachandran "jwfakouri" wrote: hey guy's, how do i write this formula? if a1=$6.80 round down to the nearest nine $6.79' if a1=$6.85 round up the nearest nine $6.89 thanks, jason -- jwfakouri ------------------------------------------------------------------------ jwfakouri's Profile: http://www.excelforum.com/member.php...o&userid=31435 View this thread: http://www.excelforum.com/showthread...hreadid=521288 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you roud up the number in Excel please? | Excel Discussion (Misc queries) | |||
Hybrid Mode
