View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dclx10 dclx10 is offline
external usenet poster
 
Posts: 1
Default 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