If no Macros in Excel 2008, then how?

[Michael Levin]

I used to have this humble function defined in my Excel sheets; it doesn't
work now that I've upgraded to Excel 2008 on my Mac:

Function strict_chi(a, b, c, d)
N = a + b + c + d
chi = (N * pow(Abs(a * d - b * c) - N / 2#, 2#) / ((a + b) * (c + d) * (a +
c) * (b + d)))
strict_chi = chi
End Function

how do I define this so that all my old Excel sheets that reference it
work? Is that possible?

Mike

 

[Bob Greenblatt]

I used to have this humble function defined in my Excel sheets; it doesn't
work now that I've upgraded to Excel 2008 on my Mac:

Function strict_chi(a, b, c, d)
N = a + b + c + d
chi = (N * pow(Abs(a * d - b * c) - N / 2#, 2#) / ((a + b) * (c + d) * (a +
c) * (b + d)))
strict_chi = chi
End Function

how do I define this so that all my old Excel sheets that reference it
work? Is that possible?

Mike

Your only options are:
1. Recode it in the XLM macro language.
2. Pay somebody to do it for you.
3. Wait for the next version of Office
4. Downgrade to Excel 2004
5. Purchase Parallels, windows, and Windows Office and run it under windows.

 

[Mike Middleton]

Mike -

If "pow" is really "power," then, since your function doesn't have any
loops, you should be able to perform its calculations in worksheet cells.

Of course, you won't be able to use the function by entering =strict_chi(a,
b, c, d) into a worksheet cell, but you could use four cells as the input
cells and (after the intermediate calculations) another cell for the
calculated value.

- Mike
http://www.MikeMiddleton.com

 

[Michael Levin]

Your only options are:
1. Recode it in the XLM macro language.

thanks! Is there a tutorial on the language and using it from Excel?
I've done a bit of googling but am not seeing what I need. Is there a "best"
URL to learn about this method?

Mike

 

[Bob Greenblatt]

thanks! Is there a tutorial on the language and using it from Excel?
I've done a bit of googling but am not seeing what I need. Is there a "best"
URL to learn about this method?

Mike

Unfortunately there is not a tutorial. Perhaps you could find an old
excel book that covers this. XLM went out of favor with Excel 5 a long
time ago, but the macros continue to work.