LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
expatrie
 
Posts: n/a
Default Excel should calculate exponentials properly (right to left)

As a structural engineer, I have occasional need for exponentials of
exponentials - Excel does not calculate these correctly - right to left, so I
need to put extra parentheses in the formula to adjust.

I encounter this problem with column design stress calculations, if anybody
cares. Proper scientific calculation order is
1) exponentials - right to left
2) multiplication and division left to right
3) addition and subtraction left to right.

It would be nice if Excel would follow this method so I don't need to
remember special rules for formulas in Excel that don't correspond to more
involved math oriented programs like mathematica or MathCAD. It would also
make using the program easier for structural engineers like me.



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions
 
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
how do you calculate "dividend yield using Excel? Dennis Excel Discussion (Misc queries) 1 June 20th 05 02:03 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
How does Excel 2003 calculate trendlines with respect to axes? BeefmanSteve Charts and Charting in Excel 2 December 22nd 04 10:53 PM
how do i calculate a chart gradient in excel? Nay Charts and Charting in Excel 1 December 14th 04 04:54 PM
Does Excel 2000 have a 'datedif' function to calculate the number. Kaddy Excel Worksheet Functions 7 December 11th 04 08:53 PM


All times are GMT +1. The time now is 06:40 PM.

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

About Us

"It's about Microsoft Excel"