Member Login

Contact Us
US +1 617 5008224
EU +44 113 8152220
Toll Free: Skype
Forum or Email
Like this Page?
 Tweet
Follow Us

Our Feeds

Who's Online

We have 32 guests and 49 members online

Total Downloads

206487
ï»¿

Enter Amount:

Home
Signup Now! Subscribe, login and start downloading. Latest Calculations! Follow us on Twitter.

ExcelCalcs
 Welcome, Guest Please Login or Register.    Lost Password?
Formula displays and square roots (1 viewing) (1) Guest
Use this forum to discuss any problems, user suggestions or any other issue regarding the XLC software.
 Favoured: 0
TOPIC: Formula displays and square roots
#81
(User)
Frog (Gold Boarder)
Posts: 20

 Formula displays and square roots 6 Years, 2 Months ago Karma: 5 See below: =(J9/4)*((J10/J9)-J11)^2 Eqn. 1 =(J9/4)*POWER((J10/J9)-J11,2) Eqn. 2 Both formulas do the same thing. ExcelCalcs provides two different presentations. The preferred ExcelCalcs display would be from Eqn. 1. Will ExelCalcs be able to understand Eqn. 2 in the future? Also, the square root displays the radical without the line above the radicand. In the example on the website, the line is there. And just for curiosity, will it display the index for values other than two?

Logged
The administrator has disabled public write access.
#83
(Admin)
Mechanical Engineer.
Moderator
Posts: 1366

 Re:Formula displays and square roots 6 Years, 2 Months ago Karma: 482 Thanks for the question. In answer to the first part there are no plans to interpret the POWER() function. Generally speaking the way you input your formula will have an effect on how the equation is drawn. I am mainly worried about introducing anomalies with particular functions. For now I would keep using the '^' operator it produces a better mathematical representation. The line above the radicand (and you have taught me a new word today) only appears if the SQRT() function is nested around OVD() and UND() functions. e.g. SQRT(OVD(J10)/UND(J9))

Logged

Last Edit: 2008/05/15 14:32 By JohnDoyle.

The administrator has disabled public write access.
#1084
(User)
Tadpole with legs (Senior Boarder)
Posts: 6

 Re:Formula displays and square roots 5 Years ago Karma: 0 Wow tnx for answering this question sir! I was about to ask the same question about the line above the 'radicand'. Big help! -Maxx JohnDoyle wrote: Thanks for the question. In answer to the first part there are no plans to interpret the POWER() function. Generally speaking the way you input your formula will have an effect on how the equation is drawn. I am mainly worried about introducing anomalies with particular functions. For now I would keep using the '^' operator it produces a better mathematical representation. The line above the radicand (and you have taught me a new word today) only appears if the SQRT() function is nested around OVD() and UND() functions. e.g. SQRT(OVD(J10)/UND(J9))

Logged

Last Edit: 2008/05/15 14:32 By JohnDoyle.
The administrator has disabled public write access.
#2806
(User)
Egg (Fresh Boarder)
Posts: 1

 Re:Formula displays and square roots 1 Year ago Karma: 0 How about cube or higher roots? would like it to look as nice as possible. JimR

Logged
The administrator has disabled public write access.

Training Courses For London Underground

"Thanks again for your excellent course this past week." "Thank you for the course last week, found it very interesting both from the perspective of a quick refresh, but also on how we can optimise the work we do." "Thanks for a very interesting and usef...

Try Excel 2013 for Free!

I am pleased to report that XLC Ribbon works with the 32bit and 64 bit versions of Excel 2013 obtained using the free Office 365 Home Premium Preview. Excel 2013 looks a little flat and dull compared to previous versions but I think this is the influence of the new Windows 8 'metro' look and f...

Introducing XLC the Ribbon Version

New!XLC Ribbon    For the first time XLC works with both 32 bit and 64 bit versions of Excel with an enhanced Office Ribbon display. It is a much simpler installation process than the previous Toolbar versions so you can be up and running in no time at all. ...

ExcelCalcs Bites the Bullet!

Hitachi have recently been awarded the largest ever UK rolling stock order and they’ll be bringing their Shinkansen bullet train technology to Europe. In August ExcelCalcs braved the stifling Japanese heat to deliver their ‘Fatigue of Welded Structures’ course to Hitachi b...

Engineer's Excel!

Our XLC software is a mathematical add-in for Excel. Generating equations direct from cell formulas it is an essential verification tool for engineers. Furthermore the ExcelCalcs community is the world’s most active producer of Excel solutions to engineering problems. The table below shows w...

ExcelCalcs Lego-Like Way to Engineering

Like a child selecting parts to construct a Lego model engineers bring together blocks of science to create new designs. These building blocks could be a load calculation, a beam calculation, a weld calculation, a fatigue calculation or any other calculation from a myriad of engineering topics. As...

iPhone, Android and Mobile Device Access

The site is optimised for browsing on mobile devices like the iPhone or Android phones. To create a web app icon browse to http://www.excelcalcs.com/navigate/ and ‘Add to Home Screen’. You will find an icon much like an app icon on your home screen which will bring you straight back...

ExcelCalcs Trailblazers

I have been chasing up feedback from new users signing up to XLC Pro accounts in the last month. I am delighted with their positive feedback. “I started using XLC but I am now insisting that my whole team use the add-in .“ “It is a great tool for validation and pres...

Increasing Engineering Confidence

Engineering training - “I run a team of engineers and whilst there are plenty of soft options for training expounding the latest management techniques there is precious little to develop the engineering skills of my team”. This is a familiar story we hear from clients of our trai...