Multi part if statement

Hi Everyone,

I tried searching for this formula, but I can't seem to find it.

Essentially I want to to create a formula that states =If(N1="Partial" OR "Full", concatenate(B1,c2),N/A)

In English, if a certain cell contains the text partial or full, concatenate, if not output an error.

Thanks for your help in advance!

Wow. Thanks for the help.

This community is so helpful, learning tons.

Creating a bit more of a complex formula would there by any way to address the "OOPS". Would there be a way to create a formula for this rather than multiple formulas. For instance, any time it isn't "partial" or "full", it is typically 1 of 3 possibilities:

1. "Partial on abcdef"
- I need to take a unique 6 alpha character phrase and concat it with C2
- Therefore if it isn't solely Partial or Full, I could take the abcdef and concat it with C2

2. "Full (1.11)"
-I need to take the number in case it fails (OOPS) and concat it with B2

3. "25.90 on abcdef, 141.91 on ghijkl, 903.03 on mnopqr"
- For this example, I would need to concat the number and 6 alpha characters. 25.90abcdef

Note: Dollar amounts can vary (be as little as a few cents) and for phase 3 it can be as much as 3 different concat's as little as 2 (90.90abcdef. 3222.90ghijkl)

I don't know if it can be done, sounds very complex.

Please find the doc attached. Hope that helps. Sample Doc.xlsx

Hi ,

try This function

Punnam