View Single Post
  #1  
Old July 23rd, 2004, 05:17 PM
Paul
external usenet poster
 
Posts: n/a
Default "Between" Formula

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!