Forum Discussion
Excel formulas
Hi , I am having trouble translating this formula and wondered if I could get some help. =IF(p3<>1,IF(AND(L3=1,OR(S3=1,U3=1,W3=1,AE3=1,AL3=1,OR(AND(E3=DATE(2020,2,2),F3=DATE(2020,12,31))))),1,0)0) ...
=IF(P3<>1,IF(AND(L3=1,OR(S3=1,U3=1,W3=1,AE3=1,AL3=1,OR(AND(E3=DATE(2020,2,2),F3=DATE(2020,12,31))))),1,0),0)
I suppose a single " , " before the last " 0 " is missing in the formula.
Can you please translate this formula. I think it's reading like this.
If p3 not equal to 1 and l3=1 and one following equals 1. S3,u3,w3,ae3,al3 or
P3<>1 and l3 and either e3=date(2020,2,2) or f3=date(2020,12,31) then result is 1. If not result is zero is that correct?
If p3 not equal to 1 and l3=1 and one following equals 1. S3,u3,w3,ae3,al3 or
P3<>1 and l3 and either e3=date(2020,2,2) or f3=date(2020,12,31) then result is 1. If not result is zero is that correct?
=IF(OR(AND(P3<>1,I3=1,OR(S3=1,U3=1,W3=1,AE3=1,AL3=1)),AND(P3<>1,I3=1,OR(E3=DATE(2020,2,2),F3=DATE(2020,12,31)))),1,0)
In my understanding what you are looking for should be above formula.