Forum Discussion
IFS with nested FIND formulas
New here so forgive me. I'm trying to use a formula to look for a text within a cell. Typically the cell will have XX/6A/XXXX -or- XX/10A/XXXX -or- XX/16A/XXXX -or- XX/20A/XXXX -or- XX/32A/XXX...
Hello phitchman66,
That could be something like:
=IF(
NOT(
ISERR(
FIND(
"64A",
A3
)
)
),
"INSERT VALUE",
IF(
NOT(
ISERR(
FIND(
"32A",
A3
)
)
),
"INSERT VALUE",
IF(
NOT(
ISERR(
FIND(
"20A",
A3
)
)
),
"INSERT VALUE",
IF(
NOT(
ISERR(
FIND(
"16A",
A3
)
)
),
0.96,
IF(
NOT(
ISERR(
FIND(
"10A",
A3
)
)
),
"1.37",
IF(
NOT(
ISERR(
FIND(
"6A",
A3
)
)
),
"INSERT VALUE",
)
)
)
)
)
)
PReaganthanks, I'll give it a try...