Get instant live expert help on if else statements in r

“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 need a nested IF formula. I want it to return a value if it meets one of 6 options. Here is my formula: =IF(R$4=$G39,$F153*$F$140,IF(R$4=$G39+$E$147,$F153*$F$147,IF(R$4=$G39+$E$143,$F153*$F$143,IF(R$4=$G39+$E$144,$G153*$F$144,IF(R$4=$G39+$E$145,$F153*$F$145,IF(R$4=$G39+$E$146,$F153*$F$146,0)))))) But it only returns the first one and everything else is 0.
Solved by G. H. in 28 mins
.... If statements If Statements and more If statements..continued
Solved by E. E. in 24 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
I'm trying to nest more than 7 IF statements, along with IF(AND(OR) statements within one cell.
Solved by Z. Y. in 18 mins
I am calculating the time between two times, an order being placed and order being delivered. I used =TEXT($R$2-$E$2,"h:mm:ss") to get this. I'm now trying to use an IF Function to say that if the time is <45 mins, say it's "fast" else, "slow". I have tried: =if((TEXT($R$2-$E$2,"h:mm:ss"))<time(0,45,00),"fast","slow") but everything returns as slow, which isn't correct. Can you help?
Solved by X. U. in 23 mins