search

LesterLyu / fast-formula-parser

Parse and evaluate MS Excel formula in javascript.
https://www.npmjs.com/package/fast-formula-parser
MIT License
462 stars 64 forks source link

Add support for IFS formulae #21

Closed rswheeldon closed 4 years ago

rswheeldon commented 4 years ago

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 4 years ago

Ok. I'll take a look.

LesterLyu commented 4 years ago

Updated: https://github.com/LesterLyu/fast-formula-parser/releases/tag/1.0.17

rswheeldon commented 4 years ago

That works. Many thanks.