Hi Abhishek, I hope this will help you.
=IF(A2="A+",IF(B2="Cartons",IF(C2>=1,"Yes","No"),IF(B2="Bales",IF (C2>=1.5,"Yes","No"),IF(B2="Pallets",IF(C2>=2,"Yes","No"),IF (B2="Others",IF(C2>=3,"Yes","No"),))))) This formula assumes that Column A, B and C contains Category, Type of Cargo and Time taken respectively. Also remove the hour/hours in time taken using find and replace. Cheers, Valli On Jan 22, 1:35 am, Abhishek Jain <abhishek....@gmail.com> wrote: > * > URGENT* > > Hi friends, > > Please help me on this: > > Category Type of Cargo Time > taken > A+ Cartons 1 > hour > A+ Bales > 1.5 hours > A+ Pallets 2 > hours > A+ Others 3 > hours > > I want to check the time taken and show the result as "Yes" or "No" as > detailed hereunder - > > > If the category is *not equal to* "A+" *- formula should return > > FALSE*(this is the first condition to be checked) > > If category is "A+" and Type of Cargo is "Cartons" and Time taken is more > > than 1 hour - it should say "Yes"> If category is "A+" and Type > of Cargo is "Bales" and Time taken is more > > than 1.5 hour - it should say "Yes"> If category is "A+" and > Type of Cargo is "Pallets" and Time taken is more > > than 2 hours - it should say "Yes"> If category is "A+" and Type > of Cargo is "Others" and Time taken is more > > than 3 hours - it should say "Yes" > Else > It should say "No" > > Please help me writing an if statement (or whatever that works) for this. > > Thanks in advance, > > Best regards, > > AJ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
