document.write( "Question 1087118: please help me with this.\r
\n" ); document.write( "\n" ); document.write( "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. \n" ); document.write( "
Algebra.Com's Answer #701417 by Theo(13342)\"\" \"About 
You can put this solution on YOUR website!
let the cell = E5\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "in the cell next to it, use the following code.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "=if(and(E5>=96,E5<=97),15,\"\")\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "if the value in cell E5 is >= 96 and <= 97, the value of the cell next to it will be 15.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "if not, the value of the cell next to it will be \"\", which is null.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "you can replace \"\" with anything that you want, like:\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "\"out of range\" or some other number, like 0.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "here's some instructions on using if statement with and and or.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "http://www.experiglot.com/2006/12/11/how-to-use-nested-if-statements-in-excel-with-and-or-not/\r
\n" ); document.write( "
\n" ); document.write( "
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( " \n" ); document.write( "
\n" );