Skip to main content

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? 

have 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

You 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! 😊

Reply


Terms & Conditions