Displaying a number with different decimals depending on a condition

[JGarces]

Hi all,

Anyone knows of a formula or combination of formulas to display a
number with different decimals depending on a condition?

for example;
If condition A is met, display number with no decimals
if condition B is met, display number with 2 decimals
and
if condition c is met, display number with 4 decimals

help will be greatly appreciated

Thanks ----
Juan Garces

 

[Guest]

you can do this with a custom number format. Here is a sample format. It is
somewhat limited (I don't think you can have more than three options).

[<=100]0.0000;[<=200]0.00;0