Forum Discussion
Excel ± percentages or figures
Dear Community, I am trying to produce an Excel formula, where the answer hinges on a ±percentage. An “IF” formula that returns 3 variables would be ideal, but Excel (it appears) only allows 2...
Hi Philip8023
in C5
=XLOOKUP(x,
CHOOSE(SEQUENCE(2), y-Var*100, y+Var*100+10^-8),
{"Within Range","Above Range"},
"Below Range",
-1
)in C6
=IFERROR(
LOOKUP(x,
CHOOSE({1,2}, y-Var*100, y+Var*100+10^-8),
{"Within Range","Above Range"}
),
"Below Range"
)