significant digits

From: "Oluwa KuIse" <wespeakforex@xxxxxxxxx>
Date: Mon, 6 Oct 2008 04:35:03 +0000 (UTC)

Hello, everyone,
How do I make the result of a calculation to exactly n significant digits. The "format" commands are not flexible in this regard.
e.g. say I want to calculate pi to an accuracy of n significant digits.
.

Follow-Ups:
- Re: significant digits
  - From: Husam Aldahiyat
- Re: significant digits
  - From: Walter Roberson
- Re: significant digits
  - From: Nasser Abbasi

Prev by Date: Loading different Simulink models into a GUI
Next by Date: Re: significant digits
Previous by thread: Loading different Simulink models into a GUI
Next by thread: Re: significant digits
Index(es):
- Date
- Thread

Relevant Pages

Re: significant figures
... For VB 6 in Excel 2003, Format does not seem to format beyond 15 significant digits. ... The reason I returned a variant is because the Format function is not limited to 14 significant digits as you have said... ... Of course, to hold the accuracy, this value must be preserved as a String. ...
(microsoft.public.excel.worksheet.functions)
Re: minimal-width E or ES format
... |> | specify the number of significant digits that need to be output and have ... I don't think there is a G format which will ... appropriate advice when you don't specify what you want? ... output and have the minimum field width adjust as necessary. ...
(comp.lang.fortran)
Re: minimal-width E or ES format
... | specify the number of significant digits that need to be output and have ... | straightforward to do with fortran format fields. ... G format is spectacularly bad about that. ... Different array elements sometimes varied widely in magnitude even ...
(comp.lang.fortran)
Re: minimal-width E or ES format
... |> | specify the number of significant digits that need to be output and have ... it can't possibly accomplish that because it is defined to use F ... I don't think there is a G format which will ... | to switch between F and E type output formats because G switches at ...
(comp.lang.fortran)
Re: 3 most significant digits
... The only way you will be able to display the trailing zeroes is by changing the cell's format to Text or to modify the code to have it change the cell's format on the fly to a custom format that displays your 3 significant figures. ... By the way, will it ever be possible for your numbers to be in e-notation and, if so, would you want the number in front of the "e" to be rounded to 3 significant digits? ...
(microsoft.public.excel.programming)