Get instant live expert help on which statement is true

“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

Strike off all rows below the row where the statement is true till it reaches the row with same value
Solved by M. E. in 12 mins
Hello I wanted to use indirect function to get a formula from a cell if a statement is true
Solved by Z. F. in 19 mins
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
I need a formula which pulls the value if it is true in 2 categories.
Solved by K. H. in 11 mins
what should i write on an if statement to not have the value changed if its true
Solved by D. H. in 28 mins