AboutPricing

Get instant live expert help on I need help with excel vba if then else

“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.
< Go Back

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

    excel vba code if then else - why does the code stop if meets the first condition
    Solved by C. Y. in 21 mins
    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
    How do I state a formula in Excel that posits if (cell location) = blank then insert blank else do formula?
    Solved by V. Q. in 21 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
    I have VBA code in my spreadsheet that looks at the values of certain cells and carries out Else/IF statements based on them. What I need to figure out is how to ensure that my code doesn't send an auto email to someone if there is a date already in the Email Sent field (row P) ' Check if due date is soon If Len(sh.Cells(cl.Row, "N")) = 0 And cl.Value <= DueDate And sh.Cells(cl.Row, "P") <> TodayDate Then ' Check due or overdue If cl.Value < TodayDate Then TypeDue = TodayDate - cl.Value & " days overdue." Else TypeDue = "due in " & DueDate - TodayDate & " days" End If
    Solved by G. J. in 28 mins