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 calcul...
SergeiBaklan
Apr 22, 2019Diamond 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),..