Results 1 to 3 of 3

Specifying a Range and Inserting into Formula

This is a discussion on Specifying a Range and Inserting into Formula within the Excel Questions forums, part of the Question Forums category; Hello, I'm sure this is something easy, but I've been working on it for a while now and I cannot ...

  1. #1
    New Member
    Join Date
    Feb 2006
    Posts
    3

    Default Specifying a Range and Inserting into Formula

    Hello,

    I'm sure this is something easy, but I've been working on it for a while now and I cannot seem to make any progress.

    Suppose I have a column of numbers representing a pressure trace versus time. Basically, these numbers increase gradually until they reach a peak and then they decrease. I need to calculate the slope of this curve from 20% to 70% of the peak pressure acheived.

    I can use excel to calculate both 20% and 70% of the peak pressure. I can even make excel return the cell address of those values in the column of data. I can then use the SLOPE function to find the slope over that range. Unfortunately, I cannot seem to nest the percentage calculations into the SLOPE formula in such a way that works. I need a range for the SLOPE formula, but I'd prefer to not have to specify each range by hand.

    In the hopes of being clearer, consider this example:

    The 20% value lies in $A$10.
    The 70% value lies in $A$90.

    I can manually type the range "$A$10:$A$90" into the SLOPE formula, but I was hoping for an automatice way of doing this.

    I can show you what i've come up with so far, but A) it's long and involved and B) it doesn't work! Thank you in advance for any insight or things to search you can help me with.

  2. #2
    New Member
    Join Date
    Feb 2006
    Posts
    3

    Default Re: Specifying a Range and Inserting into Formula

    I could use some help. I'm looking into a user defined function, but that is still a bit unclear to me.

    Thanks!

  3. #3
    New Member
    Join Date
    Feb 2006
    Posts
    3

    Default Re: Specifying a Range and Inserting into Formula

    I'm still stuck on this. Any help is appreciated. Thank you.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com