 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2007USE 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<12>6,"GOLD", IF(A2>=5,IF(B2<=6,"SILVER"))) PLS DO THE NEEDFUL REGARDS, DEEN 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<12>6),"GOLD",IF(AND(A2>=5,B2<=6),"SILVER"))) Regards, Paul > HI, > [quoted text clipped - 19 lines] > > DEEN 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 > 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<12>6),"GOLD",IF(AND(A2>=5,B2<=6),"SILVER"))) [quoted text clipped - 25 lines] > > > DEEN > THX a LOT, > [quoted text clipped - 50 lines] > > > > DEEN Hi > =IF(B2>=12,=B2/=C2), Try =IF(B2>=12,B2/C2,"")  SignatureRegards Roger Govier >> THX a LOT, >> [quoted text clipped - 50 lines] >> >> > > DEEN On Jun 16, 1:01 pm, "Roger Govier" <r...@technologyNOSPAM4u.co.uk> wrote: > Hi > [quoted text clipped - 62 lines] > > >> > > 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 > On Jun 16, 1:01 pm, "Roger Govier" <r...@technologyNOSPAM4u.co.uk> > wrote: [quoted text clipped - 72 lines] > > PLS DO ME A FAVOUR Try this: =IF(B2="","",IF(B2>=10,B2/C2,B2*C2)) Biff Hi Is it =IF(A2>=12,"PLA",IF(AND(A2>10,B2>6),"GOLD",IF(AND(A2>=5,B2<6),"SILVER",""))) SignatureRegards Roger Govier > HI, > [quoted text clipped - 19 lines] > > DEEN |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.