Nested IF with = and <= choices
 

Here is the formula I am trying to make work:
=IF(B14+B15<25,1,IF(B14+B15=25<40,2,IF(B14+B15=4 0<75,3,IF(B14+B15=75,5))))

B14 and B15 values change, and I want to return a number if the value of
B14+B15 falls within those given parameters. As shown, it gives me a FALSE
value if the sum of B14+B15 is over 25.

Nested IF with = and <= choices
 

=IF(B14+B15<25,1,IF(B14+B15<40,2,IF(B14+B15<75,3,5 )))
This formula now states if B14+B15 is less than 25, show 1, else
if B14+B15 is less than 40, show 2 (note: it has already resolved for values
under 25, so you don't need to check for that again). And so forth.
--
John C


"Clark" wrote:

Here is the formula I am trying to make work:
=IF(B14+B15<25,1,IF(B14+B15=25<40,2,IF(B14+B15=4 0<75,3,IF(B14+B15=75,5))))

B14 and B15 values change, and I want to return a number if the value of
B14+B15 falls within those given parameters. As shown, it gives me a FALSE
value if the sum of B14+B15 is over 25.

Nested IF with = and <= choices
 

As the first IF checks for <25, the formula will only evaluate the
second IF if the condition is not satisfied, i.e. B14+B15 must be
greater than or equal to 25, so you don't need to test for that
explicitly. Hence, your formula becomes:

=IF(B14+B15<25,1,IF(B14+B15<40,2,IF(B14+B15<75,3,5 ))*)

Hope this helps.

Pete

On Aug 1, 5:19*pm, Clark wrote:
Here is the formula I am trying to make work:
=IF(B14+B15<25,1,IF(B14+B15=25<40,2,IF(B14+B15=4 0<75,3,IF(B14+B15=75,5))*))

B14 and B15 values change, and I want to return a number if the value of
B14+B15 falls within those given parameters. *As shown, it gives me a FALSE
value if the sum of B14+B15 is over 25.

Nested IF with = and <= choices
 

Thanks John and Pete, I should have seen that myself.

"Pete_UK" wrote:

As the first IF checks for <25, the formula will only evaluate the
second IF if the condition is not satisfied, i.e. B14+B15 must be
greater than or equal to 25, so you don't need to test for that
explicitly. Hence, your formula becomes:

=IF(B14+B15<25,1,IF(B14+B15<40,2,IF(B14+B15<75,3,5 ))Â*)

Hope this helps.

Pete

On Aug 1, 5:19 pm, Clark wrote:
Here is the formula I am trying to make work:
=IF(B14+B15<25,1,IF(B14+B15=25<40,2,IF(B14+B15=4 0<75,3,IF(B14+B15=75,5))Â*))

B14 and B15 values change, and I want to return a number if the value of
B14+B15 falls within those given parameters. As shown, it gives me a FALSE
value if the sum of B14+B15 is over 25.

Nested IF with = and <= choices
 

You're welcome - thanks for feeding back.

Pete

On Aug 1, 5:48*pm, Clark wrote:
Thanks John and Pete, I should have seen that myself.