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
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
Try
=ROUND(A1+0.01,1)-0.01
=ROUND(A15,0)-0.1
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"jwfakouri" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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"
<[email protected]> wrote in
message
news:[email protected]...
>
> 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
>
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks