Number of Digit after the coma depending on the value

[Phil6128]

Hello,

Here is my concern:
I wish to automatize the display of digit after the coma based on the value.
For instance if the result of a calculation made in a cell is: 9.8, I wish Excel to display 9.8 but if the value becomes higher than 100, I wish Excel to remove the digit after the coma. For instance if the result of a calculation is: 102.8, I wish Excel to round it and display 103.
Or it would be even more flexible if I could set a value, for instance 90 so that when the result of my calculation is above 90, it does not display the digit anymore.

Thank you for your help. This is a big issue for me.

Phil

[NickyC]

Hi
try applying a custom format:

[<100]#,##0.0 ;#,##0

[Pepe Le Mokko]

If you only want to adapt the formatting try [<100]00.0;[>=100]000;General as Custom Formay

[Phil6128]

If you only want to adapt the formatting try [<100]00.0;[>=100]000;General as Custom Formay

Thank you very much to both of you. I implemented it in the Excel sheets I use for some procedures of our Biomedical Research Institut (University).
Thank you again.

[Phil6128]

Thank you very much to both of you. I implemented it in the Excel sheets I use for some procedures of our Biomedical Research Institut (University).
Thank you again.

The thing I don't understand thought is the fact I cannot enter more than 2 conditions:
[<100]0.0;[>=100]000 works but if I add another conditions do that 50 is not displayed with a digit after the dot then Excel refuses the formula:
[<100]0.0;[>=100]000;[=50]00

Any idea?

Phil

[vlady]

hello
if equal to 50 then 00
if less than 101( include 100) 0.0
else 000



[=50]00;[<101]0.0;000