I'm creating sort of a "calculator" that will show a specific Zone. So I got 8 different zones 1-8. Each zone got a span of kilometers. So Zone 1 (0-3km) Zone 2 (3-6km) and so on...
So if the total distance is 8km I want it to show "Zone 3" I tried to use the "IF" formula but kinda unsure how to code it to feel everything between 0-30km and then specify the correct Zone for it.
Someone willing to help me out?
Bookmarks