"Between" Formula
Hi
one way:
=IF(AND(A1=1,A1=10),1,"other value")
--
Regards
Frank Kabel
Frankfurt, Germany
Paul wrote:
HELP!
I'm trying to create a formula that displays a variable
(5, 7, 8, etc) when the value cell in question lies
between two constants...?!
A simple example would be:
If D5 is between 1 and 10 then say "1", but if D5 is
between 11 and 20 then say "2", and so on...
Is there any way of doing this? I'm begining to think
not!?!
Thank you to anyone who can help me!
|