Returning Different Values in IF Function based on 2 Different Cells

[JACKOJNR]

Hi,

I have a spreadsheet that I want to return 2 different values to a cell based on data from 2 different cells, if that makes sense

This is my current IF function =IF(F6<$Y$3,"Overdue","") which works fine, however I also want it to look at column 'I' and if the value in column 'I' is 100%, then I want it to return "Complete", rather then "Overdue".

Any help is appreciated.

Thanks

 

[Jonmo1]

Welcome to the board.

So If column I = 100%, the cell should be "Complete" Regardless of the value in F6?
Try
=IF(I6=100%,"Complete",IF(F6<$Y$3,"Overdue",""))

 

[JACKOJNR]

Thanks so much. Yep, if the value of column I = 100%, the cell should be complete.

Your formula worked perfectly, thanks so much for your help.