If function based on TBD cells w/3 options

07/22/21 Edited 07/22/21

I'm trying to create an email subject line helper cell for my projects. Different project numbers are added throughout my project's life. I start with a VRE#, then later get a Site#, then lastly get a Store#.

Those numbers are always added in that order.

Can you help me write a function for:

If site# and store# are TBD use function in line 10

If site# is TBD use function in line 9

If all 3 are present, use function in row 8

I added a ' in the first column for you to see the functions for each. Hope this makes sense!

Best Answer


Sign In or Register to comment.