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

Similar Threads

Round up or down to $X.X9 or up to $X.X5 10
Time Sum in Excel 1
Round one cell depending on value of another 3
Calculate to the third decimal and round up or down in cell 6
Nested IF/OR/AND Statement Help 3
Round down a weighted average 2
Hiding Columns in a Datasheet Subform Based on an Option Box Selection 2
how to always round numbers up 4

Top