Heyo!
I'm stratching my head as to how exactly format a formula down to first .00 numbers for an email automation.
Inspite what I've attempted it continues to display all 13 numbers for "M1" calcuation. Screenshots attached.
Solved
Formula formatting for Email merge field
+2Best answer by Zack_S
Wrap all your calculations in ROUND({calculation}, 2)
This should work
IF({Cycle} = "W1", ROUND({Rent P/W}, 2),0) + IF({Cycle} = "W2", ROUND({Rent P/W}*2, 2),0) + IF({Cycle} = "M1", ROUND({Rent P/W}*365/84, 2),0)
+17Wrap all your calculations in ROUND({calculation}, 2)
This should work
IF({Cycle} = "W1", ROUND({Rent P/W}, 2),0) + IF({Cycle} = "W2", ROUND({Rent P/W}*2, 2),0) + IF({Cycle} = "M1", ROUND({Rent P/W}*365/84, 2),0)+2Wrap all your calculations in ROUND({calculation}, 2)
This should work
IF({Cycle} = "W1", ROUND({Rent P/W}, 2),0) + IF({Cycle} = "W2", ROUND({Rent P/W}*2, 2),0) + IF({Cycle} = "M1", ROUND({Rent P/W}*365/84, 2),0)It did! Thank you very much!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.