Round numbers up or down and always end in an 8
Thank you works great - One other question - can this formula be embedded
within another formula?
--
jpizel
"Teethless mama" wrote:
=ROUNDDOWN(A1,-1)+8
"jpizel" wrote:
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
--
jpizel
|