Help using IF to return different values based on dates

Hello, First I have to admit I am not a super excel user in fact pretty much a hack trying to learn on the fly. That being said I am trying to create a formula use IF based on dates to return one of 3 results. Basically I am trying to incorporate the following:

Projected completion date > Actual Date it would return one value, if it was < it would return a different value, and if it was >but -5 would return yet another value. The values are just text

In this example I am returning a value of "Yes" but I am not sure how or if I can accomplish the other 2 returned values using the IF command.
=IF(M16>L16,Data!B7)

Sorry if this is confusing or not well explained

Hi 61dtl, welcome to the forum. "Nest" a second IF function in the false branch, as follows: (with your own return values)

Please Login or Register  to view this content.

You're most welcome, thank you for the rep!