Nested IF can often be avoided by using IF AND, like: =IF(AND(C12="Y",D12="Y"),500,0)
@skip0318906 ай бұрын
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