Get instant live expert help on I need help with excel if and statement

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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
Need help with IF SUM statement in excel.
Solved by T. S. in 14 mins
Hi, i need some help with writing a complex excel formula using a multiple if / if and / if or statement.
Solved by B. A. in 11 mins
Need help creating an if then statement in Excel.
Solved by E. C. in 13 mins