Round numbers up or down and always end in an 8

J

jpizel

I have a pricing spreadsheet with formulas that calculate my retail pricing.
The pricing column has numbers for example $547, $342, $146 etc. I would like
them all to end with an 8. $548, $348, $148 etc etc.
Does anyone have any suggestion on a formula to make all my retail pricing
end in an 8?

Thank you in advance
 
T

T. Valko

Try this:

=FLOOR(A1,10)+8

Decimal values will be rounded to integers that end in 8:

14.95 = 18
18.88 = 18
 
J

jpizel

Thank you works great - One other question - can this formula be embedded
within another formula?
 

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

Top