Formula containing If / Roundup and Text functions, some give decimals, some dont ?!

Hello people,

I have been working on a terms and conditions in excel, so that the value's; euro's/dollars automatically change (multiply with exchange rate).
Now as you can see i want the value's to come in between the text, which i have managed to do so, however in some formula's the numbers come out with decimals, and some don't. I don't really mind with or without but it has to be the same for all the conditions (allthough i prefer with 2 decimals).

1st formula - with decimals (despite the roundup being set to round up with no decimals.

Formula:

Please Login or Register  to view this content.

2nd formula - Euro's 2 decimals, dollars none (note that the only difference is #,##00 / 0,##, i have tried making 0,## --> #,##00 but nothing changed)

Formula:

Please Login or Register  to view this content.

3rd formula - Both work, without decimals

Formula:

Please Login or Register  to view this content.

If anyone can tell me what I am doing wrong, i would greatly appreciate that. I am very confused since the only formula that is set to show 0 decimals is showing decimals.

Try it with a format string of "0,00" if you want two decimal places, and with "0" if you don't want any.

Hope this helps.

Pete

With format string you mean what i have as #,##00 / 0,## etc?

I tried making that 0,00 but it doesn't seem to have any effect.

It took me some time, but i finally found the issue,

Formula:

Please Login or Register  to view this content.

I had to swap the &" per extra day." and the "0,##") part!

Closed!