View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jpizel jpizel is offline
external usenet poster
 
Posts: 2
Default 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