Forum Discussion
If functions with but and or nested
I need help. this is my problem... If C25>3000 and C21>5 then put "green" but if C25>=1000 and/or C21>3 then put "blue" but if C25>=500 and/or C21>1 then put "red" if not then put "pink" ¦....
FreePilot That could be:
= IF(OR(AND(C23="",C24=""),AND(C25 > 3000, C21 > 5)), "VFR", IF(AND(C25 >= 1000, C21 >= 3), "MVFR", IF(AND(C25 >= 500, C21 >= 1), "IFR", "LIFR")))
Hate to bother you again but there's a slight bug. If C21 is less than 5 the outcome should change the titles ex MVFR or ifr etc....
When I tried C23 and C24 to be blank but C21 to be (example) 0.9. Then the outcome should be "LIFR" but it comes out VFR. This bug only happens when C23 and C24 are left blank. Any other test, the forma is working properly.
When I tried C23 and C24 to be blank but C21 to be (example) 0.9. Then the outcome should be "LIFR" but it comes out VFR. This bug only happens when C23 and C24 are left blank. Any other test, the forma is working properly.