|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
USE IF CONDITION FOR 2DATA
"deen" wrote in message oups.com... 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 Try this: =IF(B2="","",IF(B2=10,B2/C2,B2*C2)) Biff |
| All times are GMT +1. The time now is 04:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com