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.
Page 1 / 1
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)
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)It did! Thank you very much!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.