I'm using iPad numbers and need help writing an IF equation. Basically I would like a value in one cell to result in another cell being filled with one of four word. Here goes my poorly written example (hope it makes sense)
if A1 has a value over 12,000 A2 should read "Word1" but if it's under 12,000 but over 6,000 A2 should read "Word2" but if it's under 6,000 but over 2,000 A2 should read "Word3" but if it's under 2,000 A2 should read "Word4"
Thats at the best way I can explain it. Any assistance would be appreciated.
if A1 has a value over 12,000 A2 should read "Word1" but if it's under 12,000 but over 6,000 A2 should read "Word2" but if it's under 6,000 but over 2,000 A2 should read "Word3" but if it's under 2,000 A2 should read "Word4"
Thats at the best way I can explain it. Any assistance would be appreciated.