Populate a value based on text or characters in another cell

[ultracyclist]

I want to write a formula in column J that does the following actions

1. If there is any text or characters in rows F2:F100, it should populate the value Pending in rows J2:J100
2. If there is any text or characters in rows G2:G100, it should populate the value In Progress in rows J2:J100

Any suggestions would be appreciated

Thanks,
Tom

 

[arun_eagertolearn]

Assuming cells would be blank in case there is no text/character
value pending is in column H, value in progress in column I

j2=if(isblank(f2),if(isblank(g2)," ",i2),h2) and so on

 

[Fluff]

Another option

=IF(G2<>"","In Progress",IF(F2<>"","Pending",""))

 

[ultracyclist]

Another option

=IF(G2<>"","In Progress",IF(F2<>"","Pending",""))

Another option

=IF(G2<>"","In Progress",IF(F2<>"","Pending",""))

I tried your first suggestion- =IF(G2<>"","In Progress",IF(F2<>"","Pending","")) and it populated Pending as expected when text was in F2.

What I want the formula to do is, if both F2 and G2 are populated it should change the value to "In Progress" If only F2 is populated it should just show Pending.

Hope that helps.

 

[Fluff]

That's what the formula does do.

 

[ultracyclist]

I found my mistake. I checked again and its working.

Thank you again for your help.

 

[Fluff]

Glad we could help & thanks for the feedback.