LesterLyu/fast-formula-parser

Add support for IFS formulae

Closed this issue · 3 comments

rswheeldon commented

Excel supports IFS formulae in which pairs of (condition, value) are evaluated and the first matching one wins.
e.g.

=IFS(1=3,"Not me", 1=2, "Me neither", 1=1, "Yes me")

returns

Yes me

fast-formula-parser throws errors when I try and use these.

LesterLyu commented

Ok. I'll take a look.

rswheeldon commented

That works. Many thanks.