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?

Cells value
Excel arrow keys not moving cells - Guide
Based on the values in cells b77 b81 c77 - Excel Forum
Arrow keys scrolling in Excel ✓ - Excel Forum
How to delete cells in word - Guide
Based on the values in cells b77 b81 what function can automatically return the value in cell c77 ✓ - 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

help me to add particular cells

Clear cell contents based on value of another cell range using VBA

Return Seq Values Until Blank value then return different set of seq values

Fill adjacent cell with number from text answer

Name Values

Similar discussions

Subscribe To Our Newsletter!