How can i set the result of my roundup formula to a fixed two decimal places?

Platform discussions
,
1

How can i set the result of my roundup formula to a fixed two decimal places? I want all my roundups to have 2 decimal places no matter the result. If the result is 12.6, the outcome of my roundup formula should be 12.60. Is this not a possible in Monday or do i need to adjust my formula? My current formula is: ROUNDUP({Precise subtotal},2). Thank you in advance!

3

Hey @Jerrel,

You can use TEXT function and the format “##.##”

For example -

TEXT(AVERAGE({Manager Avg},{Teammate Avg},{Support Avg})**,“##.##“)

image (150)

Let me know if this helps!

4

Hello Bianca,

Thank you very much, i adjusted the formula slightly and got the right result i needed. For my case the following formula worked: TEXT(AVERAGE({Precise subtotal}),‘##.##’). It might be because my case is a bit different that your formula did not work right away. Even though, you set me on the right path, thank you!

1 Like
5

Ah thank you for letting me know Jerrel, apologies that it took some tweaking! I am happy to hear you were able to resolve this though :slight_smile: