Soldato
- Joined
- 26 Aug 2003
- Posts
- 24,289
Sup!
I'm actually using Apple Numbers but IF formulas and I believe lookups work the same way, so I figured I would be much more likely to get an answer in here.
What I am trying to is this. There will be a number in a cell.
If it's less than £25000 I want it to return 0
If it's £25000 or more, but less than £30000, I want it to return £100
If it's £30000 or more but less than £35000, I want it to return £200
If it's £35000 or more but less than £40000, I want it to return £300
and so on up to say £60000.
I'm really struggling, I think it's the number range being involved that's confusing me!
I also found something while trying to find this mentioning a vlookup, and how it's better, but I didn't 100% understand it. Would a vlookup be better?
Thanks, I'm pulling my hair out!
I'm actually using Apple Numbers but IF formulas and I believe lookups work the same way, so I figured I would be much more likely to get an answer in here.
What I am trying to is this. There will be a number in a cell.
If it's less than £25000 I want it to return 0
If it's £25000 or more, but less than £30000, I want it to return £100
If it's £30000 or more but less than £35000, I want it to return £200
If it's £35000 or more but less than £40000, I want it to return £300
and so on up to say £60000.
I'm really struggling, I think it's the number range being involved that's confusing me!
I also found something while trying to find this mentioning a vlookup, and how it's better, but I didn't 100% understand it. Would a vlookup be better?
Thanks, I'm pulling my hair out!