IF B13= any cells in B3:F3,B5:F5,B7:F7 AND IF THAT COMBINATION IN B4:F4,B6:F6,B8:F8 =L1 OR DT1,L1.5 OR DT1.T ADD ALL 1s AND 1.5s.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Formula help
0
Post Edited
Title: Title was not descriptive.
Discussion
If you were to explain more exactly what you want I suppose that a formula like that could be written, given two or three hours time. However, the result will not be worth the effort because the formula will be so complicated that no one can really ever know if it works correctly, and there will be no one to check or correct it. Therefore I suggest you modify your worksheet to require less complicated formulas which you can trust and maintain.
Variatus (rep: 4889) Aug 26, '17 at 11:44 pm
Can't help you unless you clearly explain what needs to be done (confusing description). Provide a sample before and after worksheet and that's a good step in the right direction.
don (rep: 1989) Aug 28, '17 at 11:38 am