ExcelBanter - View Single Post - Set value for a cell basd on another cells value using an incremen

Try:

CEILING(V,10)/2

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk

"adheit" wrote in message
...
How do I set a value for a cell based on another cells value using
increment.

if cell b6 is V then cell b7 is Y based on the following interval:

V = 1-10 then Y = 5
V = 11-20 then Y = 10
V + 21-30 then Y= 15

The actual table to be used has 30 intervals.

Thanks for your help