rounding up to the 0.97
 

i work in retail and i am looking to multiply the wholesalers cost by a
2.3 margin and round up that number to the next .97. example cost is
$6.70 and you multiply that by 2.3 and you get $15.41. but i would like
that retail price to $15.97. any ideas would be very helpful. thanks for
your time
dclx10


--
dclx10
------------------------------------------------------------------------
dclx10's Profile: http://www.excelforum.com/member.php...o&userid=33748
View this thread: http://www.excelforum.com/showthread...hreadid=535257

rounding up to the 0.97
 

Is this what you want

=ROUNDUP(A1+0.03,0)-0.03

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dclx10" wrote in
message ...

i work in retail and i am looking to multiply the wholesalers cost by a
2.3 margin and round up that number to the next .97. example cost is
$6.70 and you multiply that by 2.3 and you get $15.41. but i would like
that retail price to $15.97. any ideas would be very helpful. thanks for
your time
dclx10


--
dclx10
------------------------------------------------------------------------
dclx10's Profile:
http://www.excelforum.com/member.php...o&userid=33748
View this thread: http://www.excelforum.com/showthread...hreadid=535257