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

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

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

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

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