Formula Question:

[Webem0ch]

Hi - I am looking for a way to refer to a grouping of numbers.

cell Formula sample: =IF((L32=50),N17,P17)

My goal is to replace the "50" within above formula with a statemen
that would say if L32 = anywhere between 40 and 50 then N17 if no
between 40 and 50 then P17.

Advance thanks

 

[Jason Morin]

Several ways...here's 2:

=IF(AND(L32>=40,L32<=50),N17,P17)

or

=IF((L32>=40)*(L32<=50),N17,P17)

HTH
Jason
Atlanta, GA

 

[Alan]

One of no doubt several ways,
=IF(AND(L32>=40,L32<=50),N17,P17)
Regards,
Alan.