Hello,

I would like to create a custom number format that varies depending on the
value in a cell. Not sure if this is possible. Different volume liquid
dispensers that I work with have changing accuracies depending on the amount
to dispense. I would like a single number format that would take all of these
into account.

For a value of 0 = 0
0 to 2 = nearest even thousandth (1.002 or 1.004)
2 to 10 = nearest 100th
10 to 20 = nearest even 100th
20 to 100 = nearest 10th
100 to 200 = nearest even 10th
200 = nearest integer

I don't want the value of the cell to change, just the displayed format. Not
sure if this is even possible as it seems complex for number formatting.
Thanks for any advice.
-wox