Knowing too much about Excel not a good thing...

[AvcGJS]

I was recently stumped in an excel test by the question make it say true next to all values greater than 3 and less than 6 ...with a formula.

I was stumped because confronted with that in real life i wouldn't use a formula, i'd hit the filters and type TRUE next to them, or maybe use a bit of macro code like this ....
If ActiveCell.Offset(0, -1) >= 3 And ActiveCell.Offset(0, -1) <= 6 Then ActiveCell = "TRUE"


so i became a victim of perhaps knowing the hard way but not the easy way....(it's an AND formula)

 

[xenou]

I habitually use 0's and 1's instead of actual TRUE and FALSE:
=(A1>3)*(A1<6)

Probably I would also not get credit for my answer