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

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