Help with custom formatting of a cell

[larkmore]

I am trying to set up a format rule so that I can change the display
of a number based upon its magnitude as follows:

if the number is greater than or equal to 0.1 -> display it as "0.10
A"
else if the number is greater than or equal to 0.0001 -> display it as
"0.10 mA"
else if the number is greater than or equal to 0.0000001 -> display it
as "0.10 uA"
else if the number is greater than or equal to 0.0000000001 -> display
it as "0.10 nA"
else if the number is greater than or equal to 0.0000000000001 ->
display it as "0.10 pA"
else display it in scientific notation as "1.0e-9 A"

I managed to create a custom format that can recognize two sets of
units (A, mA) but not more than that. It also won't do the
multiplication to shift the decimal point. What I have as the formula
for custom formatting:

[<0.01]0.000" mA";[>=0.01]0.000" A";General

Some more examples of what I want it to look like

1.2345 -> 1.23 A
0.00324 -> 3.24 mA
0.000099 -> 99 mA

Anyone know how to do this?
-Will