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.
--
HTH...

Jim Thomlinson


"WAR" wrote:

Thanks, Judith!

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

Wayne

"JudithJubilee" wrote:

Hi War,

Try this:

=if(A1=6,200,if(A13,200,50))


--
Hope this helps


"WAR" wrote:

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!