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