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
Bookmarks