I am trying to compose a zoom level for a map URL based on acres.
So if less than 0.5 I want zoom to =20.
I can figure that much out =IF(A2<0.5, 20)
What would create formula to say if between 0.5 and 3 acres then zoom equals 19
How could I create formula that would encompass everything i.e.
If less than 0.5 zoom = 20
if between 0.5 and 5 zoom = 19
if between 5 and 20 zoom = 18
if between 20 and 50 zoom = 17
if between 50 and 200 zoom = 16
if between 200 and 500 zoom = 15
if between 500 and 1000 zoom = 14
if between 1000 and 5000 zoom = 13
if greater than 5000 zoom = 12
so that I could simply copy formula all the way down instead of sorting and creating new formula for each range of acres.
For some reason it is not allowing me to attach XLS, but here is screenshot of what I am working with. the Longitude and Latitude columns are irrelevant, only working with the Acres column.
zoom-sample.png
Bookmarks