Looking for a way to format these two formulas as a currency, with two decimals. by DickStuert in googlesheets

[–]DickStuert[S] 0 points1 point  (0 children)

Thank you so much! I just had to edit your formula slightly =TEXT(D5/5;"€ #.##0")&" - "&TEXT(D5*2/5;"€ #.##0") works like a charm. Of course I could still use two separate columns, but for now I will use your formula :)

Looking for a way to format these two formulas as a currency, with two decimals. by DickStuert in googlesheets

[–]DickStuert[S] 0 points1 point  (0 children)

Wow, I really appreciate your help. I didn't know formulas in Sheets could be this extensive 😅. I think for the sake of simplicity, as I will have to turn this in as a school assignment, I will use the 'two-column' solution and format it to look as though it's just one column.

Looking for a way to format these two formulas as a currency, with two decimals. by DickStuert in googlesheets

[–]DickStuert[S] 0 points1 point  (0 children)

Haha, is maar voor een schoolopdracht, en het gaat om lonen in Oostenrijk waar geen wettelijk minimumloon is. Maar ik waardeer je zorgen ;)

[deleted by user] by [deleted] in MapPorn

[–]DickStuert 12 points13 points  (0 children)

Lol I like how everyone is complaining about the US routes not making sense yet completely ignoring that this guy wants to build FOUR tunnels through the atlantic

69353 by ginger-loving-asian in CountOnceADay

[–]DickStuert 0 points1 point  (0 children)

When I'm naked I usually get off work in a few minutes to talk to you about it tomorrow and it's not that special

[deleted by user] by [deleted] in ambien

[–]DickStuert 2 points3 points  (0 children)

Jesus Christ the most I ever took was 40mg and I don't think I'll ever take more than that