Formula formatting for Email merge field

[Daniel_Boys]

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.

[Zack_S · Accepted solution]

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)

[Daniel_Boys]

It did! Thank you very much!