conditional custom number format

Hello,

I am trying to create a number format for formatting resistor value in their most commonly displayed form. For example 1,200 ohms would be displayed as 1.2kΩ and 5,000,000 ohms would be displayed as 5MΩ, and finally 5 ohms would be displayed as 5Ω.

I have been able to create a format that formats any 2 contiguous formats but not all three.

for example: [>999999]###.0,,ΜΩ;[<1000000]###.0,kΩ;
or: [>999]###.0,kΩ;[<1000]###Ω

both work.(other similar criteria work as well) But if I try to put 3 conditions describing the desired formatting I get and error (containing no useful info) as I try to close the formatting dialog.

Is there a limit to the number of conditions that can be used. Or something else I'm overlooking.

Any help would be greatly appreciated.

rbailets

Could you consider using an additional row or column to hold an IF function which will display the value in the desired manner eg if a value is entered in B1 but displayed in say B3, the following formula entered in B3 would get the required results:

Please Login or Register  to view this content.

According to the note in the last item in the table on this site, you cannot have more than 2 conditions for a number format

Custom Formats