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

1. ## 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!

2. ## 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

news:Xns965AB9F87592Cmikioigtenet@216.168.3.44...
>
> 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!
>

3. ## 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 ...

news:#T44soCXFHA.1240@TK2MSFTNGP14.phx.gbl:

> 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. ## 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

news:Xns965ABCF06443Amikioigtenet@216.168.3.44...
> 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 ...
>
> news:#T44soCXFHA.1240@TK2MSFTNGP14.phx.gbl:
>
> > 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. ## 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

news:Xns965ABCF06443Amikioigtenet@216.168.3.44...
> 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 ...
>
> news:#T44soCXFHA.1240@TK2MSFTNGP14.phx.gbl:
>
>> 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. ## 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!

"Biff" <biffinpitt@comcast.net> wrote in
news:uk2#T7CXFHA.2740@TK2MSFTNGP14.phx.gbl:

> 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" <mikioi@TAKEOUTgte.net> wrote in message
> news:Xns965ABCF06443Amikioigtenet@216.168.3.44...
>> 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 ...
>>
>> news:#T44soCXFHA.1240@TK2MSFTNGP14.phx.gbl:
>>
>>> 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. ## 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

>
> 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!
>
>

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

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

"=?Utf-8?B?SkJvdWx0b24=?=" <JBoulton@discussions.microsoft.com> wrote in
news:7284A7B1-FAE9-48E6-A47D-9838197D4CDF@microsoft.com:

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

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

--
Jim

> This is EXACTLY what I was looking for...
> Thanks a bunch!
>
>
> "=?Utf-8?B?SkJvdWx0b24=?=" <JBoulton@discussions.microsoft.com> wrote in
> news:7284A7B1-FAE9-48E6-A47D-9838197D4CDF@microsoft.com:
>
> > Try this.
> >
> > =SUMPRODUCT(--(D13:D373>0),--(J13:J373=0),C13:C373)

>
>

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

#### 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