Returning 3 possible outcomes

[Stumped1978]

Hi all,

So I want to return either "Overdue, Due or (Blank)" outcomes based on three values from a cell:

if Cell AF260 is less than 0 - Return "overdue" in cell AN260
if Cell AF260 is greater than or equal to 0 but less than or equal to 4 - Return "due" in cell AN260
if Cell AF260 is greater than 4 - Return "nothing(Blank)" in cell AN260

In cell AN260 it will either say due, overdue or will have no value depending on the value in cell AF260.

However (and here is the curveball!) if the value in cell F260 reads "N" than AN260 will always return no value (Blank) regardless of AF260.

Hope that makes sense.

Thanks in advance!

 

[Leo Skywalker]

Formula in AN260, two options:

=IF(F260="N","",IF(AF260<0,"Overdue",IF(AF260<=4,"Due","")))

=IFS(F260="N","",AF260<0,"Overdue",AF260<=4,"Due",TRUE,"")