Hi i am quite new to Excel still learning a lot with the help of this forum. You guys are my guardian angels. I wonder if someone could help me in combining multiple if statements i have attached the workbook along with. Your help is much appreciated.
You only provided limited data to test with, but give this a try...
=IF(A2>30,30*10,IF(AND(A2<7,OR(B2="M",B2="E",B2="C")),A2*C2,A2*10))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Fill in D2 and copy down
Please Login or Register to view this content.
@ mehmetcik I think you have a reference wrong there?
=IF(AND(B2<7
B2 contains letter, I think you meant A2?
Thanks a lot guys, It works like a charm. You guys are amazing. But i still need to learn a lot from you. Many thanks again and hopefully i can count on you in future.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks