Checking Cell Value against a Range of Numbers

Closed

Maverick81 Posts 1 Registration date Monday December 29, 2014 Status Member Last seen December 29, 2014 - Dec 29, 2014 at 01:20 PM
shanthich Posts 5 Registration date Monday December 29, 2014 Status Member Last seen December 30, 2014 - Dec 29, 2014 at 01:34 PM

Hello,

I want to check a cell's value and if it falls in a particular range then I want to write "OK" in some other cell and if it falls out of specific range then I want to write "NOT OK".

For example if the value in cell A1 is less than -1 or greater than 1 then i want to write NOT OK in B1 and if the value of cell A1 falls in between -1 and 1 then I want to write OK in cell B1.

Can anyone tell me how to do that in excel 2010?

Checking Cell Value against a Range of Numbers
Maximum active checking torrents - Guide
Ps3 checking network configuration ✓ - PS3 & PS4 Forum
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
Excel if range of cells contains specific text then return value ✓ - Excel Forum
If cell contains date then return value ✓ - Excel Forum

1 response

Answer 1 / 1

shanthich Posts 5 Registration date Monday December 29, 2014 Status Member Last seen December 30, 2014 1
Dec 29, 2014 at 01:34 PM

use formula
IF(OR(A1<-1,A1>1),"NOT OK","OK")

Similar discussions

If a cell contains any text then add a value

Cant connect to wifi

Excel Macro/Code help: Creating sheet for each name in column of another sheet

Fixing Your PS3 Network Connection

If cell = date return yes or no.

Similar discussions

Subscribe To Our Newsletter!