Excel

  dogbreath1 16:10 23 Aug 2010
Locked

A formula in one cell of a worksheet I'm using would normally return a value between (and could include) 0 and 20.

For values between (and including) 0 and 5, I want that cell to display the value 5.

For values between (and including) 6 and 10, I want that same cell to display the value 10.

For values between (and including) 11 and 15, I want that same cell to display the value 15.

For values between (and including) 16 and 20, I want that same cell to display the value 20.

Looking for the way to do this.

TIA

db.

  VoG II 16:29 23 Aug 2010

=LOOKUP(A1,{0,6,11,16},{5,10,15,20})

=CEILING(A1,5)

  dogbreath1 16:55 23 Aug 2010

Thsnks, VoG™.

The first formula worked like a treat!

Cheers,

db.

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?