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

  • Thread starter Thread starter LavaDude
  • Start date Start date
L

LavaDude

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...
 
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
 
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 ...
 
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
Click to expand...

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
 
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
 
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...
 
Back
Top