Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple logics in one formula | Excel Worksheet Functions | |||
Multiple Logics to be looked at | Excel Worksheet Functions | |||
Creating a formula that uses multiple logics. | New Users to Excel | |||
filters logics | Excel Worksheet Functions |