SOLUTION: please help me with this. in excel, i need to check a value of a cell, whether that value is between 96.0 -97.0 the it should return the value as 15 in next cell.

Question 1087118: please help me with this.
in excel, i need to check a value of a cell, whether that value is between 96.0 -97.0 the it should return the value as 15 in next cell.
Answer by Theo(13342) (Show Source): You can put this solution on YOUR website!
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.

http://www.experiglot.com/2006/12/11/how-to-use-nested-if-statements-in-excel-with-and-or-not/

RELATED QUESTIONS
Refining the "What-If-Analysis" to make a better Decision Support System Step 1... (answered by solver91311)