I would like to be able to enter numbers in a cell and have the number of
significant figures automatically corrected defined by the following table

Number Report to nearest
0 -1.0 0.05
1 - 10 0.1
10 - 40 1
40 - 100 5
100 - 400 10