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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 09:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com