Re: Scientific notation
- From: "macropod" <invalid@xxxxxxxxxxxxxxx>
- Date: Sun, 21 May 2006 09:20:13 +1000
Hi Mark,
The following compound field will return the scientific notation of any +ve
value between 10^-9 and 10^9:
{QUOTE
{SET a {SourceVal}}
{SET
b{=9-(a<10^9)-(a<10^8)-(a<10^7)-(a<10^6)-(a<10^5)-(a<10^4)-(a<10^3)-(a<10^2)
-(a<10^1)-(a<10^0)-(a<10^-1)-(a<10^-2)-(a<10^-3)-(a<10^-4)-(a<10^-5)-(a<10^-
6)-(a<10^-7)-(a<10^-8)}}
{SET c{=int(a/10^b)+mod(a,10^b)/10^b}}
{c \# 0.00}E{b \# +00;-00}}
where 'SourceVal' is the input, which could be a formula taking its input
from two formfields. You can extend the range easily enough by adding more
terms.
All the field braces (i.e. { }) are created in pairs via Ctrl-F9. I've laid
the coding out with line breaks to separate the key portions of the coding,
but you don't really need them.
Cheers
"MarkTheNuke" <MarkTheNuke@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BE775318-3245-4336-B815-0AE9FC3FF542@xxxxxxxxxxxxxxxx
How do I display the results of a calculated field in scientific notation.
Is this possible. Thanks in advance.
.
- Prev by Date: Re: Saving merge main documents to the web
- Next by Date: Re: Document for email with picture linked to URL (Word 2002)
- Previous by thread: Re: Scientific notation
- Next by thread: Re: Word - Excel DDE Connection Difficulties(ver 2002)
- Index(es):
Relevant Pages
|
