+ Reply to Thread
Results 1 to 9 of 9

Formula needed: Return cell value in a range depending on other cell values

  1. #1
    LavaDude
    Guest

    Formula needed: Return cell value in a range depending on other cell values


    Hi All!

    I have a mortgage amortization spreadsheet where I'd like the value in
    Column C to be returned if the value in Column D is greater than zero and
    the value in column J is equal to zero...

    The range for Column C is C13:C373...

    Something like: If column D > 0 and column J = 0, return column C

    If you need more enough, please post a reply and I'll try to make myself
    more clear.

    TIA!

    LavaDude...

  2. #2
    Mangesh
    Guest

    Re: Formula needed: Return cell value in a range depending on other cell values

    copy this formula in the required result column and drag down.
    =IF(AND(D1>0,J1=0),C1,"")

    if the condition is satisfied, it will return a value from column C,
    otherwise it will put a blank.

    Mangesh



    "LavaDude" <[email protected]> wrote in message
    news:[email protected]...
    >
    > Hi All!
    >
    > I have a mortgage amortization spreadsheet where I'd like the value in
    > Column C to be returned if the value in Column D is greater than zero and
    > the value in column J is equal to zero...
    >
    > The range for Column C is C13:C373...
    >
    > Something like: If column D > 0 and column J = 0, return column C
    >
    > If you need more enough, please post a reply and I'll try to make myself
    > more clear.
    >
    > TIA!
    >
    > LavaDude...




  3. #3
    LavaDude
    Guest

    Re: Formula needed: Return cell value in a range depending on other cell values

    Thank you for the response... Ideally I would like the formula to show up
    only in one cell... not in a range of cells (drag down) ... I suppose I
    could insert and hide a column and sum up the hidden column since only one
    row will have this condition...

    Does anyone else has a suggestion on putting the formula in only one cell?

    Thanks Mangesh ...

    "Mangesh" <[email protected]> wrote in
    news:#[email protected]:

    > copy this formula in the required result column and drag down.
    > =IF(AND(D1>0,J1=0),C1,"")
    >
    > if the condition is satisfied, it will return a value from column C,
    > otherwise it will put a blank.
    >
    > Mangesh
    >
    >


  4. #4
    Mangesh
    Guest

    Re: Formula needed: Return cell value in a range depending on other cell values

    If you could expalin a bit more clearly, someone might help. Do you have a
    value in only one cell in columns D and J, And do you want the result in a
    seperate column, or you want to modify the column C itself.

    Mangesh


    "LavaDude" <[email protected]> wrote in message
    news:[email protected]...
    > Thank you for the response... Ideally I would like the formula to show up
    > only in one cell... not in a range of cells (drag down) ... I suppose I
    > could insert and hide a column and sum up the hidden column since only one
    > row will have this condition...
    >
    > Does anyone else has a suggestion on putting the formula in only one cell?
    >
    > Thanks Mangesh ...
    >
    > "Mangesh" <[email protected]> wrote in
    > news:#[email protected]:
    >
    > > copy this formula in the required result column and drag down.
    > > =IF(AND(D1>0,J1=0),C1,"")
    > >
    > > if the condition is satisfied, it will return a value from column C,
    > > otherwise it will put a blank.
    > >
    > > Mangesh
    > >
    > >




  5. #5
    Biff
    Guest

    Re: Formula needed: Return cell value in a range depending on other cell values

    Hi!

    You need to provide a better explanation.

    >I'd like the value in Column C to be returned if the value in Column D is
    >greater than zero and the value in column J is equal >to zero...
    >The range for Column C is C13:C373...
    >Ideally I would like the formula to show up only in one cell


    Just assume for a minute that all of C13:C373 meet that condition. How do
    you get all of those values into a single cell?

    Biff

    "LavaDude" <[email protected]> wrote in message
    news:[email protected]...
    > Thank you for the response... Ideally I would like the formula to show up
    > only in one cell... not in a range of cells (drag down) ... I suppose I
    > could insert and hide a column and sum up the hidden column since only one
    > row will have this condition...
    >
    > Does anyone else has a suggestion on putting the formula in only one cell?
    >
    > Thanks Mangesh ...
    >
    > "Mangesh" <[email protected]> wrote in
    > news:#[email protected]:
    >
    >> copy this formula in the required result column and drag down.
    >> =IF(AND(D1>0,J1=0),C1,"")
    >>
    >> if the condition is satisfied, it will return a value from column C,
    >> otherwise it will put a blank.
    >>
    >> Mangesh
    >>
    >>




  6. #6
    LavaDude
    Guest

    Re: Formula needed: Return cell value in a range depending on other cell values

    I have setup the values in the columns in such a way that one row will
    have the condition requested - where D>0 and J=0 ...

    So I wanted a formula in only one cell that will find the above criteria
    in those range of cells and return the date value in Column C ...

    I hope this helps..., the formula that I received earlier from Mangesh is
    working fine right now... I just need to hide the column and use a sum
    formula to find the value since only one row will have a value.

    Thanks!

    LavaDude...

    "Biff" <[email protected]> wrote in
    news:uk2#[email protected]:

    > Hi!
    >
    > You need to provide a better explanation.
    >
    >>I'd like the value in Column C to be returned if the value in Column D
    >>is greater than zero and the value in column J is equal >to zero...
    >>The range for Column C is C13:C373...
    >>Ideally I would like the formula to show up only in one cell

    >
    > Just assume for a minute that all of C13:C373 meet that condition. How
    > do you get all of those values into a single cell?
    >
    > Biff
    >
    > "LavaDude" <[email protected]> wrote in message
    > news:[email protected]...
    >> Thank you for the response... Ideally I would like the formula to
    >> show up only in one cell... not in a range of cells (drag down) ... I
    >> suppose I could insert and hide a column and sum up the hidden column
    >> since only one row will have this condition...
    >>
    >> Does anyone else has a suggestion on putting the formula in only one
    >> cell?
    >>
    >> Thanks Mangesh ...
    >>
    >> "Mangesh" <[email protected]> wrote in
    >> news:#[email protected]:
    >>
    >>> copy this formula in the required result column and drag down.
    >>> =IF(AND(D1>0,J1=0),C1,"")
    >>>
    >>> if the condition is satisfied, it will return a value from column C,
    >>> otherwise it will put a blank.
    >>>
    >>> Mangesh
    >>>
    >>>

    >
    >
    >



  7. #7
    JBoulton
    Guest

    RE: Formula needed: Return cell value in a range depending on other c

    Try this.

    =SUMPRODUCT(--(D13:D373>0),--(J13:J373=0),C13:C373)
    --
    Jim


    "LavaDude" wrote:

    >
    > Hi All!
    >
    > I have a mortgage amortization spreadsheet where I'd like the value in
    > Column C to be returned if the value in Column D is greater than zero and
    > the value in column J is equal to zero...
    >
    > The range for Column C is C13:C373...
    >
    > Something like: If column D > 0 and column J = 0, return column C
    >
    > If you need more enough, please post a reply and I'll try to make myself
    > more clear.
    >
    > TIA!
    >
    > LavaDude...
    >


  8. #8
    LavaDude
    Guest

    RE: Formula needed: Return cell value in a range depending on other c

    This is EXACTLY what I was looking for...
    Thanks a bunch!

    LavaDude...

    "=?Utf-8?B?SkJvdWx0b24=?=" <[email protected]> wrote in
    news:[email protected]:

    > Try this.
    >
    > =SUMPRODUCT(--(D13:D373>0),--(J13:J373=0),C13:C373)



  9. #9
    JBoulton
    Guest

    RE: Formula needed: Return cell value in a range depending on oth

    Cool! Glad to help.
    --
    Jim


    "LavaDude" wrote:

    > This is EXACTLY what I was looking for...
    > Thanks a bunch!
    >
    > LavaDude...
    >
    > "=?Utf-8?B?SkJvdWx0b24=?=" <[email protected]> wrote in
    > news:[email protected]:
    >
    > > Try this.
    > >
    > > =SUMPRODUCT(--(D13:D373>0),--(J13:J373=0),C13:C373)

    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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