View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jwfakouri
 
Posts: n/a
Default 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