format decimals displayed based on results
 

Is there a way to format a cell to vary the decimals displayed based on the
results it is showing?
Ex: if the value is <100 show 4 decimal places, if it is over 100 but
less than 1000, show 2 decimals, and over 1000 show no decimals.

format decimals displayed based on results
 

Use a format of

[=1000]#,##0;[=100]#,##0.00;#,##0.0000

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"widman" wrote in message
...
Is there a way to format a cell to vary the decimals displayed based on
the
results it is showing?
Ex: if the value is <100 show 4 decimal places, if it is over 100 but
less than 1000, show 2 decimals, and over 1000 show no decimals.

format decimals displayed based on results
 

With a helper column this gets close to your needs
=ROUND(A1,5-LOG(A1))
but it show 1 decimal when A1 1000

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"widman" wrote in message
...
Is there a way to format a cell to vary the decimals displayed based on
the
results it is showing?
Ex: if the value is <100 show 4 decimal places, if it is over 100 but
less than 1000, show 2 decimals, and over 1000 show no decimals.

format decimals displayed based on results
 

thanks. That does it very nicely

"Bob Phillips" wrote:

Use a format of

[=1000]#,##0;[=100]#,##0.00;#,##0.0000

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"widman" wrote in message
...
Is there a way to format a cell to vary the decimals displayed based on
the
results it is showing?
Ex: if the value is <100 show 4 decimal places, if it is over 100 but
less than 1000, show 2 decimals, and over 1000 show no decimals.