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
#201
JohnDoyle ()
Please support us with an XLC Pro Subscription.
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, 6 Months ago Karma: 470  
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  
 
  The administrator has disabled public write access.
      Topics Author Date
    thread link
factorials Favorite
alisonm 2007/04/30 12:26
    thread link
thread linkthread link Re:factorials
JohnDoyle 2007/04/30 15:08
Go to top Post Reply