Results 1 to 7 of 7

Array around Slope and Intercept Formula

Threaded View

  1. #1
    Registered User
    Join Date
    01-08-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    10

    Array around Slope and Intercept Formula

    Hello all......I'm hoping someone can help me with an array formula please. I'm trying to put in this formula:

    =SLOPE($C$2:$C$7602,$B$2:$B$7602)*B2-ABS(INTERCEPT($C$2:$C$7602,$B$2:$B$7602))

    but with an array around it. I've attached an example of my file and what I'm after is an IF statement around it to say that I want the =SLOPE etc formula to calculate IF($A$2:$A$28=A2).

    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Graphing Using Only Slope and Y-Intercept
    By rylock in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-12-2013, 11:38 AM
  2. Slope and Intercept using Macro
    By habeebshafi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-06-2012, 12:56 PM
  3. [SOLVED] Slope/Intercept for Groups
    By jjmilla in forum Excel General
    Replies: 1
    Last Post: 03-23-2012, 02:54 PM
  4. Use criteria to calculate slope and intercept?
    By JoshuaSQ in forum Excel General
    Replies: 3
    Last Post: 12-13-2006, 03:53 PM
  5. SLOPE & INTERCEPT
    By banavas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2005, 04:42 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1