ultracyclist
Active Member
- Joined
- Oct 6, 2010
- Messages
- 271
- Office Version
- 365
- Platform
- Windows
I want to create a formula that I can carry down from rows F2:F83 on Sheet1 that has the following logic
IF C2:C83 = MS355 in Sheet1, multiply the quantity in E2:E83 (Sheet1) times the cost from sheet2 cell B4 = 450
IF C2:C83 = MS390 in Sheet1, multiply the quantity in E2:E83 (Sheet1) times the cost from sheet2 cell B7 = 700
Ex: C2 has MS355 in Sheet 1 and the quantity in E2 =12. The value returned in F2 should =$5400
C2 has MS390 in Sheet 1 and the quantity in E2 =20. The value returned in F2 should =$14000
Not sure where to start with this one. Any help would be appreciated
Thanks
Tom
IF C2:C83 = MS355 in Sheet1, multiply the quantity in E2:E83 (Sheet1) times the cost from sheet2 cell B4 = 450
IF C2:C83 = MS390 in Sheet1, multiply the quantity in E2:E83 (Sheet1) times the cost from sheet2 cell B7 = 700
Ex: C2 has MS355 in Sheet 1 and the quantity in E2 =12. The value returned in F2 should =$5400
C2 has MS390 in Sheet 1 and the quantity in E2 =20. The value returned in F2 should =$14000
Not sure where to start with this one. Any help would be appreciated
Thanks
Tom