Get instant live expert help on if vs else if

“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

Hi, can you please help me with nested IF statement in Excel? IF(A=1) else check next cell IF(B=1) else check next cell IF(C=1) then perform calculation.
Solved by C. C. in 19 mins
I need formula to express: IF (23 > 0 AND 26 > (24+ 23), 26-23-24) ELSE IF (23 <= 0 AND 26 > 24, 26 - 24) ELSE 0
Solved by M. H. in 18 mins
I need the formula that solves the following nested if for ATP: If C18 = 0 then C19 = 0 Else If D18 = 0 Then C19=MAX(C18-(C11+C12),0) Else C19=MAX(C18-(C11),0)
Solved by D. J. in 30 mins
excel vba code if then else - why does the code stop if meets the first condition
Solved by C. Y. in 21 mins
Drop down in multiple columns. I want to do a sum at the end for each column that has a specific value. S0 SUM OF If C10= "Specific_Value", (C52*D47/36), else 0, PLUS If E50= "Specific_Value", (E52*D47/36) PLUS if G50="Specific_Value" (G52*H47*36), else 0)
Solved by F. Q. in 11 mins