Excel

  dogbreath1 16:10 23 Aug 10
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 10

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

=CEILING(A1,5)

  dogbreath1 16:55 23 Aug 10

Thsnks, VoG™.

The first formula worked like a treat!

Cheers,

db.

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

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How Nearly Normal created super-fun papercraft for Google

47 iPhone camera tips to help you take better photos