IF Formula Issue

[Leecedwards]

Hi,

I am trying to write a formula where the cell will show as either Complete or Incomplete.

I want it to look into a number of cells on the same row (I4,J4,K4,L4,M4). If any of those cells contain Pending then it will show as Incomplete. If none of the cells contain Pending it well show as Complete.

Is this possible? I tried =IF(I4="Pending","Pending","Complete") which does it for one cell but how can I get it to look in the other cells to see if they contain pending. I also tried =IF(I4:M4="Pending","Pending","Complete") but get a value error?

Any help appreciated,

Lee

[cbatrody]

Hi,

Please try the following

=IF(OR(I4="Pending",J4="Pending",K4="Pending",L4="Pending",M4="Pending"),"Pending","Complete")

[martindwilson]

=IF(COUNTIF(I4:M4,"pending"),"incomplete","complete")

[sktneer]

Another.....

Please Login or Register  to view this content.

[Leecedwards]

Thank you so much all for your replies. Its working now. Really appreciated!