Formula

[Eugene748]

Help me add this formula:
=IF(SUM(C2:C12) <> SUBTOTAL(109, C2:C12), SUBTOTAL(109, C2:C12), SUM(C2:C12))

[shuchkin]

https://github.com/shuchkin/simplexlsxgen?tab=readme-ov-file#data-types

see line "Formula"

[Eugene748]

Yes, I saw an example, wrote a code based on it, but Excel gives an error
IF(SUM(C2:C12) <> SUBTOTAL(109, C2:C12), SUBTOTAL(109, C2:C12), SUM(C2:C12))

[Eugene748]

<f v="0">IF(SUM(C2:C12) <> SUBTOTAL(109, C2:C12), SUBTOTAL(109, C2:C12), SUM(C2:C12))</f>

[Eugene748]

the issue is resolved by screening <>
htmlspecialchars('IF(SUM(C2:C12) <> SUBTOTAL(109, C2:C12), SUBTOTAL(109, C2:C12), SUM(C2:C12))')

[ashokavarthanan]

How to implement IF()

'<f>'.htmlspecialchars('=+IF(J2<0,"PLUS","MINUS")').'</f>',

[shuchkin]

may be remove "="

and replace formulas, use PHP as calculator, $s . ($v < 0 ? 'PLUS' : 'MINUS')

[ashokavarthanan]

may be remove "="

and replace formulas, use PHP as calculator, $s . ($v < 0 ? 'PLUS' : 'MINUS')

Sorry that replay is Answer.

I tried IF() like ['Formula', '<f >IF(J2<0,"PLUS","MINUS"</f>'],
it show Error and not working.
this code done with success.
['Formula', '<f>'.htmlspecialchars('=+IF(J2<0,"PLUS","MINUS")').'</f>'],

Thanks for simplexlsxgen.