Formula for > but <

[Bhuktar S]

For excel sheet, is there any other way than the formula I put in cel
B1 as:
=If(AND(A1>100,A1<200),"Yes","No")
i.e. I want to detect the value in A1 if it is >100 but <200

 

[Frank Kabel]

i
what's wrong with this kind of formula. Not really a beter
way available. You may try
=If((A1>100)*(A1<200),"Yes","No")

 

[Andrew]

Try =IF(AND(A1>100,A1<200),A1,""

 

[Earl Kiosterud]

Bhuktar,

You could use Conditional Formatting to change the color or borders of the
cell itself when the value is in our range of values.