LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Andreas
 
Posts: n/a
Default Scientific formating like (a.b+-x.y) 10-z cts/sec


Complex question:

I have two inputs A & B from which I can calculate the output X plus the
error eX of the output:

That's no problem.

But I need to have it in a special scientific format:
(X +- eX) 10-Z cts/sec

Example: X = 2.3e-4, eX + 0.5e-4 then the output should be:
(2.3 +- 0.4) 10-4 cts/sec

The output should be in one cell.

How can a accomplish this?

Thanks a lot,
Andreas
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
csv converting numbers to scientific format JR Excel Discussion (Misc queries) 7 June 16th 05 12:13 AM
Conditional Formating Roy Excel Discussion (Misc queries) 4 May 27th 05 01:16 AM
Copy cell formating as part of a formula KepGuru Excel Worksheet Functions 1 March 3rd 05 05:12 PM
more than 3 conditional formating in excel Manan Excel Discussion (Misc queries) 2 February 7th 05 09:12 PM
Removing Scientific Notation Trisha Lynn New Users to Excel 8 January 20th 05 06:38 PM


All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"