Forum Discussion
accstudent
Apr 22, 2019Copper Contributor
Nested If Function Help
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.
1 Reply
- SergeiBaklanDiamond Contributor
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),..