Displaying a number with different decimals depending on a condition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JGarces - 16 Aug 2006 17:08 GMT

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

Signature

JGarces

Reply to this Message

Sloth - 16 Aug 2006 17:37 GMT

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

> Hi all,
>
[quoted text clipped - 11 lines]
> Thanks ----
> Juan Garces

Reply to this Message