Help

Re: Formula formatting for Email merge field

Solved
Jump to Solution
734 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Boys
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

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)

See Solution in Thread

2 Replies 2
Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

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!