ROUND in IF

[IvicaOS]

Hello,

please forgive if my questions are trivial but they are not so to me!



How can I put ROUND function inside the IF formula?

For Example if I have something like this in A5 cell:

=IF(D2="something";(D3/75)*100;D3*1,333333)

How and where I should put the ROUND function so that the either result would be nicely rounded?

I'd like to keep two decimal places, so choosing zero decimal places in Format Cells/Number/Decimal places is not good option for me.

Please help this novice, thanks!

[NBVC]

=ROUND(IF(D2="something";(D3/75)*100;D3*1,333333),2) would round to 2 decimals.

[IvicaOS]

Tnx very much,

but when I do that I get exactly the same result as without ROUND function. I mean exactly the same, and that number "2" at the end, that defines number of decimal places, must go after ";" and not after ",".

I was more hopping to get, for example, number 75.000,00 instead of 75.000,02 or 133.333,00 instead of 133.333,33. (if D2 is SOMETHING and D3 is 100.000,00 from my question)

Tnx!

[zbor]

You have different versions of excell.. Some of them use , instead of ;... Just adopt it as you need to, but formula is the same.

[DonkeyOte]

Again, to clarify... the ; or , is not version dependent - it is entirely down to regional settings on the client machine.

[NBVC]

Tnx very much,

but when I do that I get exactly the same result as without ROUND function. I mean exactly the same, and that number "2" at the end, that defines number of decimal places, must go after ";" and not after ",".

I was more hopping to get, for example, number 75.000,00 instead of 75.000,02 or 133.333,00 instead of 133.333,33. (if D2 is SOMETHING and D3 is 100.000,00 from my question)

Tnx!

Perhaps then:


=ROUND(IF(D2="something";(D3/75)*100;D3*1,333333);0)

formatted as Number with 2 decimal places.

[IvicaOS]

YES, YES, THAT'S IT, THAT'S IT!



Thank you very much, what I wouldn't give to have your knowlege, thanks @NBVC, and thanks to other guys for clearing up the "," or ";" issue!

Cheers!