Formula for > but <

B

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
 
F

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")
 
E

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.
 
Top