Hi everyone. I’m having trouble with the correct formula for a compounding interest slider.
I tried to use the same formula from excel but it seems the plugin doesn’t register the ^ symbol as a function?
I’ve tried:
FieldTotal*(1+FieldSliderPercentage/12)^(12*FieldSliderYears)
But the end calculation is never correct. I’ve tried several variations and when cross referencing against online compound interest calculators I can see the figures are always very far off.
Does anyone know what calculation I could use to get an accurate result?
Also as a side thing I’ve updated WP and now the sliders have a static ghost icon visible. Presume there’s an update coming that will address this?
This is the slider before and after sliding it across
https://imgur.com/a/BUJtjta