Formula help


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.

Post Edited
Title: Title was not descriptive.


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: 2225) 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: 1492) Aug 28, '17 at 11:38 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login