Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy with format | New Users to Excel | |||
Accounting format does not align decimals. | Excel Discussion (Misc queries) | |||
how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
Function Formula is displayed not results | Excel Worksheet Functions | |||
Displayed number format | Excel Worksheet Functions |