rounding up to the 0.97

  • Thread starter Thread starter dclx10
  • Start date Start date
D

dclx10

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
 
Is this what you want

=ROUNDUP(A1+0.03,0)-0.03

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing prices in multiple colunms based percentages 2
Formula for Finding Retail 1
Rounding a Rounded Number 16
ROUNDING UP TO NEAREST 9 4
Rounding Numbers into Retail Amounts 4
The Old Rounding Question 4
Rounding formulas 5
Rounding up or down 4

Back
Top