Hi
I'm trying to put together a formula that will report back on only one option out of four when valid.
1. If F15 is between -0.01 and -25000 result should be 1500
2. If F15 is between -25001 and 50000 should be 1000
3. If F15 is between -50001 and 100000 should be 750
and
4. if F15 is 100000+ = 500
I also wanted it to report 0 if F15 equals 0 or is a +ve number so started the formula with IF(F$15>=0,"",IF.....
Thing is I have four option lines.
So in line one I only want it to return the 1500 if it is less than 0 but not more than -25000 inclusive.
If it's more than -25000 than I need it to show 0 in this line and then put the correct result according to option 2 - 4..
Hope this makes sense.
I thought this was an easy one but just cannot seem to get it to work.
Thanks
I'm trying to put together a formula that will report back on only one option out of four when valid.
1. If F15 is between -0.01 and -25000 result should be 1500
2. If F15 is between -25001 and 50000 should be 1000
3. If F15 is between -50001 and 100000 should be 750
and
4. if F15 is 100000+ = 500
I also wanted it to report 0 if F15 equals 0 or is a +ve number so started the formula with IF(F$15>=0,"",IF.....
Thing is I have four option lines.
So in line one I only want it to return the 1500 if it is less than 0 but not more than -25000 inclusive.
If it's more than -25000 than I need it to show 0 in this line and then put the correct result according to option 2 - 4..
Hope this makes sense.
I thought this was an easy one but just cannot seem to get it to work.
Thanks