Forum Discussion
If functions with but and or nested
Example C21= 0.8, the outcome should be "LIFR". It doesn't, it reads "VFR"° again only when the aforementioned cells are blank.
Again only when C23 & C24 are blank the formula acts as if C21 has no influence. If there Is something in those cells the outcome is correct.
FreePilot It all comes down to clearly defining the logic for all the IFs and put them in the correct order. You mentioned " If cells C23 and C24 are left blank then "VFR". ".
That's exactly what the formula does now. As soon as both these cells are blank it returns VFR and all other conditions are ignored. If that's not what you want you need to clarify. And that's exactly what I suggested in my very first reply. Get the logic correct first, then build a formula. Not the other way around.
Nesting IF functions becomes very ugly and hard to debug if you go to deep. Using IFS, as suggested by Lorenzo might help. Or perhaps you can use a reference table specifying the applicable flight rules under different circumstances and then use any of Excel's lookup functions.
Can you otherwise upload your workbook? Or share a link to it. That would help as well.