Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2008
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    I have an equation such as the one showing up in the figure. I have all the values (X1, X2, Y1, Y2, Z1, Z2) available in a column. I also know how to create a VBA to calculate the equation. The question that I have is this: Is there a way to do the same in Excel without coding it in VBA?

    Thanks.
    Attached Images Attached Images

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You can do it with intermediate calculations (See attached).

    I don't think it can be done with aaray formulas as they would be too complex for excel to understand

    Steve
    Attached Files Attached Files

  3. #3
    2 Star Lounger
    Join Date
    Oct 2008
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Steve.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •