Percentage

[John 4348]

Hello everyone
I need a formula to determine when the percentage is 100,100,if not , show the number with 2 decimal, for example (100),(96.54).
Thanks in advance

 

[felixstraube]

You can achieve this with custom formatting like this:

[=1]0%;0.00%

Book12.xlsx
	A
1	100%
2	90.00%
3	85.00%
4	80.00%
5	70.00%
Sheet3

 

[John 4348]

You can achieve this with custom formatting like this:

[=1]0%;0.00%

Book12.xlsx
	A
1	100%
2	90.00%
3	85.00%
4	80.00%
5	70.00%
Sheet3

Thank you.
I am a bigenner at Excel, could you explain the Formula please?

 

[John 4348]

Thank you.
I am a bigenner at Excel, could you explain the Formula please?

[=1] what does it mean?

 

[felixstraube]

For values equal to 1 (100%) it applies the format 0%, for anything else it applies forma 0.00%

You hace to use it in custom formatting:

Here you can learn more about formats. Search for conditional at the bottom.:

Excel custom number formats