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


--
JGarces
------------------------------------------------------------------------
JGarces's Profile: http://www.excelforum.com/member.php...o&userid=30406
View this thread: http://www.excelforum.com/showthread...hreadid=572268

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

"JGarces" wrote:


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


--
JGarces
------------------------------------------------------------------------
JGarces's Profile: http://www.excelforum.com/member.php...o&userid=30406
View this thread: http://www.excelforum.com/showthread...hreadid=572268