Function Argument Question
 

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!

Function Argument Question
 

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!

Function Argument Question
 

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!

Function Argument Question
 

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

On 4/26/10 12:46 PM, 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!

Function Argument Question
 

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!