SpreadEveryone: The Fetchland Excel wire

2 lurkers | 101 watchers

SPR Sep 2019 7:40pm, 18 Sep 2019 29,297 posts	0 SPR Yeah, I lied as I've also used it for level of profit, in fact that's how I learned about it.
run free Sep 2019 11:32pm, 18 Sep 2019 3,548 posts	0 run free Macca - have a look at the Analysis Toolpak. 1. File Options Add-ins - look at the RHS bottom of dialog and should see a button Go. 2. Check mark the Analysis Toolpak option 3. In the Data tab, you should see an Analyze group with Data Analysis. In there is a Histogram tool that used to be able to create a bell shaped curve. Minimum points needed would be 3 points to plot a triangle..... sorry bell shaped curve
GregP Sep 2019 6:17am, 19 Sep 2019 114,914 posts	0 GregP [my final year BSC project involved recursive descent compilers - recursion seems to have rather gone out of fashion since then]
flanker Sep 2019 2:13pm, 19 Sep 2019 18,583 posts	0 flanker Glenn, luckily I've never needed to calculate internal rate of return :-). Whenever I've needed to anything recursive I've used more specialised applications or coded my own.
GlennR Sep 2019 2:22pm, 19 Sep 2019 45,092 posts	0 GlennR You can do recursive calculations in Excel if you turn iteration on in options. Can go amusingly wrong though.
run free Oct 2019 7:20pm, 1 Oct 2019 3,556 posts	0 run free Also check out Solver if you need to go further than the simple Goal Seek
Stander Oct 2019 3:10pm, 11 Oct 2019 16,106 posts	0 Stander Well, that's got to be some sort of record One find and replace substituted 2020 for 2019 over 286,000 times. On one tab.
run free Oct 2019 6:26pm, 11 Oct 2019 3,570 posts	0 run free they all being used in formulaes?
um Oct 2019 11:22pm, 11 Oct 2019 1,288 posts	0 um But was it intended Stander - or a mistake?
Stander Oct 2019 9:08am, 14 Oct 2019 16,107 posts	0 Stander All in formulae and all intended.