'IF' Function - More than 1 Logical Test's

[jamsco]

For a data set I need to create a true/false 'dummy variable'. But there
are parameters:

ie for the value 232; my test has to account whether this is higher
than or equal to the value 92, and also if it is lower than or equal to
364.

So for the value 232 would return: TRUE
but the value 2633 would return: FALSE

I would then copy formula for all the relavant data which would say
either 'TRUE' or 'FALSE'

Any help would be great.

Jamie.

 

[Arvi Laanemets]

Hi

With value to test in A1
=IF((A1>=92)*(A1<=464),TRUE,FALSE)

 

[jamsco]

Thanks,
Your equation was alot more condensed than my longwinded effort.

Jamie.