CODEWITHSUNDEEP
jexcelapijexceljs
Gustavo Menezes
Gustavo Menezes

Reputation: 137

Using conditional formulas in JExcel

I'm using the javascript library JExcel.js in version 4. I need to insert conditional formulas just like this:

=IF(A1<>0,'ZERO','NOT ZERO')

But it's giving an error. Is Jexcel able to do that?

Upvotes: 0

Views: 157

Answers (2)

Guillaume-Bo
Guillaume-Bo

Reputation: 26

Yes use same formula comparator like javascript 😊

< <= > >= != ==

On version pro (i not test on version CE, you can use for egal comparaison 1 "=")

Upvotes: 0

Gustavo Menezes
Gustavo Menezes

Reputation: 137

I solved the problem. The correct formula is

=IF(A1 !=0, 'NOT ZERO', 'ZERO')

Upvotes: 0

Related Questions