Question 1087118
let the cell = E5


in the cell next to it, use the following code.


=if(and(E5>=96,E5<=97),15,"")


if the value in cell E5 is >= 96 and <= 97, the value of the cell next to it will be 15.


if not, the value of the cell next to it will be "", which is null.


you can replace "" with anything that you want, like:


"out of range" or some other number, like 0.


here's some instructions on using if statement with and and or.


<a href = "http://www.experiglot.com/2006/12/11/how-to-use-nested-if-statements-in-excel-with-and-or-not/" target = "_blank">http://www.experiglot.com/2006/12/11/how-to-use-nested-if-statements-in-excel-with-and-or-not/</a>