Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Re:factorials (1 viewing) (1) Guest
Use this forum to discuss any problems, user suggestions or any other issue regarding the XLC software.
Go to bottom Post Reply Favoured: 1
TOPIC: Re:factorials
#200
alisonm (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
factorials 1 Year, 2 Months ago Karma: 3  
Hi, I thought I'd have a go at producing some calculations using XLC and as I am teaching the topic of Combinations and Permutations I used these formulas to have a go.
I was able to name the variables n and r easily enough and I was able to do the formulas using OVD() and UND() functions but as the formulas use factorial, which has the formula FACT() in Excel,when I use the "show equation" button it prints is using fact and not the exclamation mark notation for factorial which we use in Mathematics and Statistics.
Also the notation for Combination that we use frequently is nCr where the n should be superscript and the r subscript. Can I do this?
I know these calculations are very basic stuff but this is about as hard as some calculations get in High school maths!
Hope someone can help
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#201
JohnDoyle (Admin)
Admin
Posts: 400
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:factorials 1 Year, 2 Months ago Karma: 469  
Alison it great to see XLC being used in schools so thanks for the question. XLC will not rename the Excel's Fact() function but here is a work around. Name a cell manually "n!=" (note if the cell is named "n! =" it will be automatically subscripted which is XLC's default behaviour - omitting the 'space' before the "=" allows you to format an name any way you like - then the name is dragged into equations). This is covered in the online help just below the flash tutorial. http://www.excelcalcs.com/content/view/52/126/

I have amended and attached your calculation. I have also taken a stab at formatting nCr - but I am not totally sure what you want to achieve her. This should keep you going - keep on opening the miraculous world of maths to our young people!
File Attachment:
File Name: Combinations_and_Permutations_2.xls
File Size: 22528
 
Report to moderator   Logged Logged  
 
Talk to me about training.
Talk to me about engineering consultancy work and finite element analysis.
  The administrator has disabled public write access.
Go to top Post Reply