| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
USE IF CONDITION FOR 2DATA
HI,
In excel sheet we have data like , A B C (Avg) (Month) (Result) 12 12 PLA 11 7 GOLD 6 5 SILVER formula need like, IF(A2=12,IF(B2<=12,"PLA",IF(A2=10,IF(B2<126,"GO LD", IF(A2=5,IF(B2<=6,"SILVER"))) PLS DO THE NEEDFUL REGARDS, DEEN |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
USE IF CONDITION FOR 2DATA
What is your formula supposed to do?
This combines some of your functions =IF(AND(A2=12,B2<=12),"PLA",IF(AND(A2=10,B2<126 ),"GOLD",IF(AND(A2=5,B2<=6),"SILVER"))) Regards, Paul "deen" wrote in message ups.com... HI, In excel sheet we have data like , A B C (Avg) (Month) (Result) 12 12 PLA 11 7 GOLD 6 5 SILVER formula need like, IF(A2=12,IF(B2<=12,"PLA",IF(A2=10,IF(B2<126,"GO LD", IF(A2=5,IF(B2<=6,"SILVER"))) PLS DO THE NEEDFUL REGARDS, DEEN |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
USE IF CONDITION FOR 2DATA
THX a LOT,
i have more doubt Mr.paul, i have data like , A B C Result (Tot) (month) (A/c) 12 12 10 PLA 11 7 20 GOLD 6 5 30 GOLD i need formula like a, =IF(B2=12,=B2/=C2),"PLA","GOLD" PLS DO THE NEED FUL, REGARDS, DEEN On Jun 15, 8:30 pm, "PCLIVE" wrote: What is your formula supposed to do? This combines some of your functions =IF(AND(A2=12,B2<=12),"PLA",IF(AND(A2=10,B2<126 ),"GOLD",IF(AND(A2=5,B2<=6),"SILVER"))) Regards, Paul "deen" wrote in message ups.com... HI, In excel sheet we have data like , A B C (Avg) (Month) (Result) 12 12 PLA 11 7 GOLD 6 5 SILVER formula need like, IF(A2=12,IF(B2<=12,"PLA",IF(A2=10,IF(B2<126,"GO LD", IF(A2=5,IF(B2<=6,"SILVER"))) PLS DO THE NEEDFUL REGARDS, DEEN |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
USE IF CONDITION FOR 2DATA
On Jun 16, 8:32 am, deen wrote:
THX a LOT, i have more doubt Mr.paul, i have data like , A B C Result (Tot) (month) (A/c) 12 12 10 1.2 i need formula like a, =IF(B2=12,=B2/=C2), PLS DO THE NEED FUL, REGARDS, DEEN On Jun 15, 8:30 pm, "PCLIVE" wrote: What is your formula supposed to do? This combines some of your functions =IF(AND(A2=12,B2<=12),"PLA",IF(AND(A2=10,B2<126 ),"GOLD",IF(AND(A2=5,B2<=6),"SILVER"))) Regards, Paul "deen" wrote in message oups.com... HI, In excel sheet we have data like , A B C (Avg) (Month) (Result) 12 12 PLA 11 7 GOLD 6 5 SILVER formula need like, IF(A2=12,IF(B2<=12,"PLA",IF(A2=10,IF(B2<126,"GO LD", IF(A2=5,IF(B2<=6,"SILVER"))) PLS DO THE NEEDFUL REGARDS, DEEN |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
USE IF CONDITION FOR 2DATA
Hi
=IF(B2=12,=B2/=C2), Try =IF(B2=12,B2/C2,"") -- Regards Roger Govier "deen" wrote in message ups.com... On Jun 16, 8:32 am, deen wrote: THX a LOT, i have more doubt Mr.paul, i have data like , A B C Result (Tot) (month) (A/c) 12 12 10 1.2 i need formula like a, =IF(B2=12,=B2/=C2), PLS DO THE NEED FUL, REGARDS, DEEN On Jun 15, 8:30 pm, "PCLIVE" wrote: What is your formula supposed to do? This combines some of your functions =IF(AND(A2=12,B2<=12),"PLA",IF(AND(A2=10,B2<126 ),"GOLD",IF(AND(A2=5,B2<=6),"SILVER"))) Regards, Paul "deen" wrote in message oups.com... HI, In excel sheet we have data like , A B C (Avg) (Month) (Result) 12 12 PLA 11 7 GOLD 6 5 SILVER formula need like, IF(A2=12,IF(B2<=12,"PLA",IF(A2=10,IF(B2<126,"GO LD", IF(A2=5,IF(B2<=6,"SILVER"))) PLS DO THE NEEDFUL REGARDS, DEEN |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
USE IF CONDITION FOR 2DATA
On Jun 16, 1:01 pm, "Roger Govier"
wrote: Hi =IF(B2=12,=B2/=C2), Try =IF(B2=12,B2/C2,"") -- Regards Roger Govier "deen" wrote in message ups.com... On Jun 16, 8:32 am, deen wrote: THX a LOT, i have more doubt Mr.paul, i have data like , A B C Result (Tot) (month) (A/c) 12 12 10 1.2 i need formula like a, =IF(B2=12,=B2/=C2), PLS DO THE NEED FUL, REGARDS, DEEN On Jun 15, 8:30 pm, "PCLIVE" wrote: What is your formula supposed to do? This combines some of your functions =IF(AND(A2=12,B2<=12),"PLA",IF(AND(A2=10,B2<126 ),"GOLD",IF(AND(A2=5,B2<=6),"SILVER"))) Regards, Paul "deen" wrote in message oups.com... HI, In excel sheet we have data like , A B C (Avg) (Month) (Result) 12 12 PLA 11 7 GOLD 6 5 SILVER formula need like, IF(A2=12,IF(B2<=12,"PLA",IF(A2=10,IF(B2<126,"GO LD", IF(A2=5,IF(B2<=6,"SILVER"))) PLS DO THE NEEDFUL REGARDS, DEEN HI FRIENDS I NEE A FORMULA LIKE, =IF(AND(B2=10,B2/C2),IF(AND(b2<10,b2*c2,""))) PLS DO ME A FAVOUR |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
USE IF CONDITION FOR 2DATA
Hi
Is it =IF(A2=12,"PLA",IF(AND(A210,B26),"GOLD",IF(AND( A2=5,B2<6),"SILVER",""))) -- Regards Roger Govier "deen" wrote in message ups.com... HI, In excel sheet we have data like , A B C (Avg) (Month) (Result) 12 12 PLA 11 7 GOLD 6 5 SILVER formula need like, IF(A2=12,IF(B2<=12,"PLA",IF(A2=10,IF(B2<126,"GO LD", IF(A2=5,IF(B2<=6,"SILVER"))) PLS DO THE NEEDFUL REGARDS, DEEN |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
| How to use condition | Excel Discussion (Misc queries) | |||
| Max or Min with condition | Excel Worksheet Functions | |||
| Condition 1 overules condition 2? | Excel Worksheet Functions | |||
| How to set condition: A1=A2=A3= ... =A10 | Excel Worksheet Functions | |||
Hybrid Mode
