If-Then logics
 

Hi,

I have a work sheet with numbers in 'Column A'. In 'Column B' I wish to get
the following output:

If column A is < 3000 then give me '1'; If column B is 5000 then give me
'3'; if column A is 3000 but <5000 then give me '2'.

Kindly help.

Thanks
Rumneet

If-Then logics
 

"Rum" wrote:
I have a work sheet with numbers in 'Column A'.
In 'Column B' I wish to get the following output:
If column A is < 3000 then give me '1';
If column B is 5000 then give me '3';
if column A is 3000 but <5000 then give me '2'.

If you mean that for each cell in A, you want the corresponding cell in B to
be 1, 2 or 3, then:

=if(A1<3000, 1, if(A1<5000, 2, 3))

For such a simple choice, I think the IF expression above is the way to go.
But if you had more categories, you might want to consider VLOOKUP. For
example:

=vlookup(A1, {0,3000,5000}, {1, 2, 3})

Note: If A1 might be negative, change 0 to some very large negative number,
e.g. -1E300.


----- original message -----

"Rum" wrote:

Hi,

I have a work sheet with numbers in 'Column A'. In 'Column B' I wish to get
the following output:

If column A is < 3000 then give me '1'; If column B is 5000 then give me
'3'; if column A is 3000 but <5000 then give me '2'.

Kindly help.

Thanks
Rumneet

If-Then logics
 

Errata...


I wrote:
But if you had more categories, you might want to consider VLOOKUP.
For example:
=vlookup(A1, {0,3000,5000}, {1, 2, 3})

I meant LOOKUP, viz.:

=lookup(A1, {0,3000,5000}, {1, 2, 3})

Moreover, if the result is simply 1, 2, 3, etc, i.e. a category index, MATCH
would suffice. For example:

=match(A1, {0,3000,5000})


----- original message -----

"Joe User" <joeu2004 wrote in message
...
"Rum" wrote:
I have a work sheet with numbers in 'Column A'.
In 'Column B' I wish to get the following output:
If column A is < 3000 then give me '1';
If column B is 5000 then give me '3';
if column A is 3000 but <5000 then give me '2'.

If you mean that for each cell in A, you want the corresponding cell in B
to
be 1, 2 or 3, then:

=if(A1<3000, 1, if(A1<5000, 2, 3))

For such a simple choice, I think the IF expression above is the way to
go.
But if you had more categories, you might want to consider VLOOKUP. For
example:

=vlookup(A1, {0,3000,5000}, {1, 2, 3})

Note: If A1 might be negative, change 0 to some very large negative
number,
e.g. -1E300.


----- original message -----

"Rum" wrote:

Hi,

I have a work sheet with numbers in 'Column A'. In 'Column B' I wish to
get
the following output:

If column A is < 3000 then give me '1'; If column B is 5000 then give me
'3'; if column A is 3000 but <5000 then give me '2'.

Kindly help.

Thanks
Rumneet

If-Then logics
 

On 3/29/2010 2:46 PM, Rum wrote:
Hi,

I have a work sheet with numbers in 'Column A'. In 'Column B' I wish to get
the following output:

If column A is< 3000 then give me '1'; If column B is5000 then give me
'3'; if column A is3000 but<5000 then give me '2'.

Kindly help.

Thanks
Rumneet

Just another interesting option:

=1+(A1=3000)+(A1=5000)

= = = = = = =
HTH :)
Dana DeLouis