rounding

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?
 
H

Harald Staff

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.
 

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

rounding a number up to a certain ending digit 6
Round Function 5
I'm trying to remove duplicate phrasing and words using VBA in Word 2
How to Select Multiple Emails using Surface Pen 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
rounding up to the nearest 1000 1
Random funtion 3
Autonumber field in Excel that behaves the same as Access 0

Top