Excel Battle: IF vs IFS

[@WaldoHazeleger]

Nested IF can often be avoided by using IF AND, like: =IF(AND(C12="Y",D12="Y"),500,0)

[@skip031890]

That's exactly what I do.

[@detectivethinker3637]

This video has helped me a lot. Basically, with the IF you need to nest it after hitting the first criterium, whereas with IFs you just type whatever shows up. Initially, I have struggled with this, but I am getting to grips with this now. Thank you so much for the tutorial! It has made an academic lesson very engaging.

[@PaulEBrownbill]

Thanks for the comparison, very interesting and informative. Paul

[@ExcelU]

Thanks Paul!

[@salmaalaa6158]

very useful thank you

[@ikadconsultancytraining5112]

Nested IF is more structered when there are many conditions to check, but for 2 or 3 conditions the IF is better

[@user-mp9ji4fu8w]

need your help sir