There's probably an easier way, and I think you made a typo with your 23.15,
you meant 13.15, but here goes:
=IF(MOD(ROUNDUP(A1*2,-1),10)=0,ROUNDUP(A1*2,-1),ROUNDUP(A1*2,-1)+5)
*******************
~Anne Troy

www.OfficeArticles.com


"Running The Store" <Running The Store@discussions.microsoft.com> wrote in
message news:4FDB70B7-8CF2-43FC-B0F9-D1A014AC056D@microsoft.com...
> I am changing wholesale prices to retail prices. I want to round up the
cost
> to multipuls of $5.
> wholesale formula
> A18 =roundup (A18*2) multipuls of 5
>
> $23.15 ($26.30) desired answer $30.00
>
>