| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If question
I have three columns, A, B and C, I need a quick analysis / IF statement to
determine: If A is between B and C,"A IS GOOD" If A is below B, "INCREASE A" If A is above C, "DECREASE A". Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If question
Hi,
try =if(A1<B1,"INCREASE A",if(A1C1,"DECREASE A","IS GOOD") if this helps please click yes, thanks "tss" wrote: I have three columns, A, B and C, I need a quick analysis / IF statement to determine: If A is between B and C,"A IS GOOD" If A is below B, "INCREASE A" If A is above C, "DECREASE A". Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If question
Try this with data in A1,B1,C1
=IF(A1<B1,"INCREASE A",IF(A1<=C1,"A IS GOOD",IF(A1C1,"DECREASE A"))) If this post helps click Yes --------------- Jacob Skaria "tss" wrote: I have three columns, A, B and C, I need a quick analysis / IF statement to determine: If A is between B and C,"A IS GOOD" If A is below B, "INCREASE A" If A is above C, "DECREASE A". Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If question
MAYBE
=IF(A1<B1,"Increase A",IF(A1B1,"Decrease A","A is Good")) Mike "tss" wrote: I have three columns, A, B and C, I need a quick analysis / IF statement to determine: If A is between B and C,"A IS GOOD" If A is below B, "INCREASE A" If A is above C, "DECREASE A". Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If question
Hi
Try this: =IF(A2<B2,"Increase A",IF(A2C2,"Decrease A","A is good")) Regards, Per "tss" skrev i meddelelsen ... I have three columns, A, B and C, I need a quick analysis / IF statement to determine: If A is between B and C,"A IS GOOD" If A is below B, "INCREASE A" If A is above C, "DECREASE A". Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| question about sum | Excel Discussion (Misc queries) | |||
| where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
| =IF(OR question | Excel Worksheet Functions | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Linear Mode
