Posted to microsoft.public.excel.programming

Ryan

external usenet poster

Posts: 124

Simple custom function

I am trying to program a custom function to make some simple math simpler.
Unfortunately this is my first swing at a custom function or VBA for that
matter. I would like to be able to pass 6 variables to a function and have it
do the following math:

CrossP(A1, A2, A3, B1, B2, B3)
CrossP = ((A2 * B3 - A3 * B2) ^ 2 + (A1 * B3 - A3 * B1) ^ 2 + (A1 * B2 - A2
- B1) ^ 2) ^ 0.5

Any thoughts?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a custom function to interpret another custom engine func	Ryan	Excel Programming	0	March 3rd 08 07:18 PM
Simple problem, simple formula, no FUNCTION !	Ron@Buy	Excel Worksheet Functions	6	September 28th 07 04:51 PM
Simple Custom Function???	Mike	Excel Programming	1	August 17th 07 02:10 AM
Simple Custom Function???	Mike	Excel Programming	0	August 17th 07 01:45 AM
How to create a simple VBA Custom Function	Edmund	Excel Programming	5	May 22nd 06 08:49 PM

All times are GMT +1. The time now is 01:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us