Excel - vba or formula?

  VNAM75 19:48 18 Dec 2008
Locked

If I have a list of ages in A1:A10, in column B how do I return a corresponding age bracket?

eg.

A1 = 23
B1 = 20 to 25

  VoG II 19:59 18 Dec 2008

Try

=FLOOR(A1,5) & " to "& CEILING(A1,5)

  VNAM75 20:07 18 Dec 2008

Thanks VoG™, that works perfect.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Illustrator Sylvain Tegroeg created thousands of intricate line drawings for the mobile game…

Best iPad buying guide 2017

Comment télécharger une application indisponible en France ?