I'm writing a formula with multiple IF statements. If one IF statement comes out to be false, I want Excel to forget that component and to move on. Out of 5 or 6 if statements, I only want excel to use info from the statements that are true. For example, right now I have started with....IF(AND(IF(AND(F2=TRUE, I46= "BUY"), "BUY", (otherwise forget this statement and go to next statement...I just don't know how to code that),IF(AND F3=TRUE, J46="BUY"),"BUY" (otherwise forget this statement and go to next statement)....etc, etc. Any advice?
Solved by O. F. in 22 mins