IF Formula

[Amy33]

Hi,

I am trying to get a formula to return one of three values for two cell,

I have two cells (i.e. F11 and G11) if F11 has something in, I need cell I11 to return "In Progress" if G11 contains something then I11 to return "complete"... at this point, both F11 and G11 would have something in. If they were F11 was blank then I11 to return "Not Started"

In I11, I had =IF(F11="","Not Started",In Progress")&IF(G11="","","Complete") but it return 'In ProgressComplete' when there is a value in F11 and G11 rather than Complete

Any help would be awesome! sorry to be a pain!

Thanks

 

[tyija1995]

Hey,

try:

=IF(G11<>"","Complete",IF(F11<>"","In Progress","Not Started"))

NB: If F11 & G11 are both populated this formula ignores F11 and gives the initial value "Complete"

 

[Amy33]

That's done it, thank-you so much for your help!!

 

[tyija1995]

No problem!

Your initial formula you posted concatenates 2 IF statements, hence the "In ProgressComplete" as the & operator is used to join things - instead of concatenation you just needed to nest an extra IF function to open up the possibility to 3 different outcomes