[ad_1]
Hi there,
We have recently noticed that the price being emailed to customers has several numbers after the decimal point and was wondering how we go about rounding it to 2 decimal places.
Here’s how the price looks on the submission forms – $947.2320000000001. We would prefer it be $947.25.
Here is the current formula we are using –
IF(SUM(fieldname2,fieldname6)==0,0,IF(fieldname6<=2200,IF(fieldname2<=1100,169,IF(fieldname2>=2201,249,199)),IF(fieldname2>=2201,329,IF(fieldname2<=1100,199,IF(fieldname6>=2501,299,249)))))
Just wondering if there is anything that we can add to the formula to fix this issue?
Many thanks
The page I need help with: [log in to see the link]