IF only...

[Neozoic]

Hello Everyone,

First time poster and hoping you clever people can help me with a formula that seems beyond me. My formula is as follows:

=IF(A2<"","In Progress",IF(A2="","Dormant",IF(F2="","Complete")))

So if A2 is empty it is "Dormant", if it contains anything it is "In Progress", but it doesn't seem to like the last part of the formula where, if there is anything in F2 it overrides the first two sections and instead inserts "Complete". I'm well aware that the formula doesn't have anything in it that makes F2 override the other two functions and that is where I need the help.

The formula comes at the end of a row that includes progressive dates. The dates aren't relevant it is just that the cells contain something.

So, treat me gently - I'm a beginner - and please help.

Thanks
David

 

[Fluff]

Hi & welcome to MrExcel
How about
=IF(F2="","Complete",IF(A2="","Dormant","In Progress"))

 

[Neozoic]

Thanks Fluff.

I just tried your formula and I notice that when both A2 and F2 are blank it shows the cell with the formula as Complete however I really only want Complete to show when there is an entry in F2. If I put an entry in just A2 the formula cell still shows as Complete rather than In Progress. When both A2 and F2 are filled the forumla cell shows In Progress.

The way I want the formula to work is: If A2 is filled the formula cell shows In Progress, if A2 and F2 are filled or if just F2 is filled it shows Complete. And if A2 and F2 are blank it shows Dormant. Is this possible?

By the way I'm using Excel 2013.

Thanks

 

[Fluff]

In that case change F2= to F2<>

 

[Neozoic]

That is perfect! Thank you so much Fluff. I've got a lot to learn.

 

[Fluff]

You're welcome & thanks for the feedback