Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding and Number Formatting
I am trying to digitize an ANSI standard that calls for specific rounding and
significant figures rules. For example, variable are specified as "7 sig figs, simply rounded" or "4 places to right of decimal if pitch is greater than 40, else 3 places." I can work through the rounding, truncating, etc, but is there a way to display these significant digits within a column using one formula? So far, I've tried something like "=IF(A12/$B$1<10,ROUND(A12/$B$1,6),ROUND(A12/$B$1,5))" but that won't account for displaying. I tried conditional formatting, but that won't allow number formats. I want everything to be adaptable in case the main variables change (so I can use a template sheet and copy them programmatically). Anyone have any ideas? Thanks, Pflugs |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding and Number Formatting
Have you tried Tools, Options, Caculations, and ticked Precision as Displayed? -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=562271 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding and Number Formatting
No, I have not. I tried it now, and that will work for some instances.
However, that is not a sheet-specific setting, correct? If that's the case, I don't want that to apply to all my sheets. For now, I think I will stick to a complicated system of "round" and "fixed". Thanks for the help. Pflugs "raypayette" wrote: Have you tried Tools, Options, Caculations, and ticked Precision as Displayed? -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=562271 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cut off number in excel cell vs. rounding | Excel Discussion (Misc queries) | |||
Problems: rounding & formatting Text/# combinations | Excel Discussion (Misc queries) | |||
Problems: rounding & formatting Text/# combinations | Excel Discussion (Misc queries) | |||
Unwanted rounding of large number | Excel Worksheet Functions | |||
rounding a formula's number | Excel Worksheet Functions |