Format TEXT based on whole or decimal percentage

[ldoodle]

Hi,

I'm using TEXT with CONCATENATE to show a percentage value as text. However if I use no decimal in the formula it rounds decimal percentages which I don't want.

Is it possible to determine whole percentages and apply one format of the other?

20% = TEXT(A1,"0%") = should show as 'Total VAT (20%)'
17.5% = TEXT(A1,"0.0%") = should show as 'Total VAT (17.5%)'

ec. etc.

Thanks

[shg]

	A	B	C
2	20.0%	Total VAT (20%)	B2: ="Total VAT " & TEXT(A2, IF(MOD(A2, 1%) < 0.001, "(0%)", "(0.0%)"))
3	17.5%	Total VAT (17.5%)

[ldoodle]

Thanks very much