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.

Algebra ->  Subset -> 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.       Log On


   

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) About Me  (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/