Apr 22 2019 02:43 AM
Hi, I was hoping someone might be able to help me with this formula, or tell me why I'm getting an error. I need to check if a number fits within a certain range, and if it does, do a specific calculation, then check another range, do a calculation if it fits there, and repeat until I want it to return 0 if it does not fit within any of the multiple specified ranges.
This is a simplified version of what I'm really trying to do, but I think it's easier solved and understanding what's wrong here will let me know what's wrong in the other one I'm working on.
Thanks so much for any help.
Apr 22 2019 03:11 AM
@accstudent , the
=IF(O23<B24<P23,..
is not correct syntax, you may use
=IF(AND(O23<B24,B24<P23),..
or, what is the same
=IF((O23<B24)*(B24<P23),..