Format currency to show three different formats...

[albertc30]

Hi everyone.

It has been sometime since my last post, so I hope everyone's safe and well.

More to the point, I am trying to format a cell to show currency but I am failing misserably to come up with the correct formula

I have tried changing this "[<999950]£0.00,"K";[<999950000]£0.00,,"M";£0.00,,,"B"" but it's just not happening. The worst thing is I am quite sure this is as simple as it gets.
What I want to do is to display the cell format as >$1,000 (no decimal cases), if >$10 to show 2 decimal cases and if <$10 to show 6 decimal cases.

As always any input is trully and well very much appreciated.
Much appreciated.
Albert

 

[albertc30]

[>999]$0,000;[>10]$00.00];[<10]$0.000000]

Got me nowhere yet!

 

[ISY]

Hi

[>999] $ 0.000;[>10] $ 0,00; $ 0,000000;@

 

[Taul]

or this
[<=10]$0.000000;[>999]$0;$00.00

 

[albertc30]

or this
[<=10]$0.000000;[>999]$0;$00.00

Thanks.

Worked a treat. So simple! It only goes to show I'll never amount to much on excel.

Cheers.