I need the dollar amounts on our automated emails to be automatically rounded to the nearest cent. The automated email is pulling these figures from fields in airtable that have formulas associated already, and they are set to round to the nearest cent/hundredth, however when they come through on the automated email suddenly they include an extra place value "thousandth," and do not provide thousands comma markers or dollar signs. I do not know how to combine a ROUND formula on top of the formulas that are already on the fields. Can someone help?
+10have you tried wrapping in a ROUND and multiplying by 100 then dividing by 100? e.g .
ROUND(
({Settlement Amount} - Deductible - {Existing Claim ACV} - {JPA Fee for Settlement Email} - {Shingle Sample Company Cost} - {Tarp Fee} - {Umpire Fee}) * 100
) / 100
+6You can fix this by wrapping your existing formula inside the ROUND() function to ensure it rounds to two decimal places. Then, use & "$" to add a dollar sign and TEXT() to format with commas. Try this:
"$" & ROUND(YourFormula, 2)
Or, for comma formatting:
"$" & TEXT(ROUND(YourFormula, 2), "#,##0.00")
This will round the amount correctly, add the dollar sign, and include commas. If you need help applying it to your specific formula, let me know! 😊
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.