rounding

  • Thread starter Thread starter suzanne
  • Start date Start date
S

suzanne

I need to be able to round an answer (function) to the
nearest factor of 18. Cana anyone tell me if this is
possible, and if so how would I do it?
 
Function is in A1, or replace the "A1" part with the actual function:
=ROUND(A1/18,0)*18

HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.
 
Back
Top