I have a number in A2 (this number is always changing),so when the number changes, it needs to be reprensented in other cells with ranges..eg
A B C D
1 Cost 10-20 21-41 42-87
2 17
I want when A2 is 17, then 1 is represented in B2. When A2 changes to 21, B2 changes to 0 but C2 changes to 1. Can you help?
Bookmarks