Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do you calculate "dividend yield using Excel? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
How does Excel 2003 calculate trendlines with respect to axes? | Charts and Charting in Excel | |||
how do i calculate a chart gradient in excel? | Charts and Charting in Excel | |||
Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions |