Dynamic decimal place rounding

[MrTD]

Hi all,

I'm trying to format these percentages with rounding based on the value of each cell.

If the percentage value is less than 10% round to = #.#%
If the percentage value is less than 0.1% round to = #.##%
If the percentage value is less than 0.01% round to = #.###%

Hopefully the example below helps to demonstrate what I'm trying to achieve:

Any help would be greatly appreciated.

Many thanks

 

[Dermot]

Here is one way - format numbers using TEXT
Look up the number format from a little table (in H2:I6 in this example)
D3 =TEXT(C3, VLOOKUP(C3,$H$2:$I$6,2,TRUE))

The table would look like
0 % '0.000%
0.01% '0.00%
0.1% '0.0%
10% '0%
1