I have been searching for an answer and can't seem to find one. I multiple OR conditions within an IF statement.
What I need is:
If L3 OR M3 OR N3 or O3 OR P3 OR Q3 >0 then X3=Past
If R3 >0 then X3=Present
If S3 OR T3 or U3 or V3 > 0 then X3=Future
The problem is the following are also true:
If L3 OR M3 OR N3 or O3 OR P3 OR Q3 OR R3 > 0 then X3=Past, Present
If L3 OR M3 OR N3 or O3 OR P3 OR Q3 OR S3 OR T3 or U3 or V3 >0 then X3=Past, Future
If L3 OR M3 OR N3 or O3 OR P3 OR Q3 OR R3 OR S3 OR T3 or U3 or V3 >0 then X3=Past, Present, Future
This is my non-working code thus far:
=(IF(OR($L3>0, $M3>0, $N3>0, $O3>0, $P3>0, $Q3>0),"Past"), IF(OR($R3=0),”Present”),IF(OR($S105>0,$T105>0,$U105>0,$V105>0),"Future" ,NoDate)))
Any help is greatly appreciated!!
Aucun commentaire:
Enregistrer un commentaire