C
Clark
Here is the formula I am trying to make work:
=IF(B14+B15<25,1,IF(B14+B15>=25<40,2,IF(B14+B15>=40<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.
=IF(B14+B15<25,1,IF(B14+B15>=25<40,2,IF(B14+B15>=40<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.