Function Argument Question

[WAR]

I'm having a brain freeze and cannot come up with the formula to express the
following:

If A1 is greater than 0 but less than 3, return 50,

If A1 is greater than 3 but less than 6, return 100,

If A1 is great than 6, return 200.

I was looking for a "between" function like in formatting, but I don't think
that is how it's done.

Thanks in advance for any help!

 

[JudithJubilee]

Hi War,

Try this:

=if(A1>=6,200,if(A1>3,200,50))

 

[WAR]

Thanks, Judith!

I think you typed in an error though, should it say "A1>="? I took out the
"=" and it worked.

Wayne

 

[Dana DeLouis]

Hi. Just to mention...

If A1 is greater than 0 but less than 3, return 50,

A1 of zero, or -2 also return 50.
A1 <=0 was not specified.

Just thought I'd mention it. :>)
= = = = = =
HTH :>)
Dana DeLouis

 

[Jim Thomlinson]

You did not specify what to do if the answer was exactly 6. Less than 6 =
100. Greater than 6 = 200. Judith did not make a mistake.