Need help for a formula

D

Dot

I have tried everything I know to do and can't get this formula to work.

A1
1.0161

A2 B2 C2 D2 E2
1.0148 1.0163 1.0155 1.0164 1.0160

The above cell may or may not all be filled out, but if they are, I need a
formula that returns answer in another cell.

I need the formula to first take each cell A2 thru E2 to do: A2-A1/A1 then
Return in cell A3 if the A2-A1/A1 formula is <=.00025 and A2-B2 is <=0.0005
if, so, then B2 and then repeat on each cell A2-E2 - I can only get the
formula to return B2 and can't get it to take a look at the other cells
 
N

NBVC

Does F2 contain text

Try

=IF(ISTEXT(B2),"",IF(AND((A2-$A$1)/$A$1<=0.00025,A2-B2<=0.0005),B2,"")

copied across
 
N

NBVC

Maybe you can post the sample raw data and expected results (and
describe how the expected results came to be)
 
E

Eduardo

Hi,
try entering in cell A3
=IF(AND((A2-$A$1)/$A$1<=0.00025,A2-B2<=0.0005),B2,"")

and in cell B3

=IF(A3="","",IF(AND((B2-$A$1)/$A$1<=0.00025,B2-C2<=0.0005),C2,""))

copy this formula to your right
 
D

Dot

The formula is great, that's what I had but I need it to keep going thru E2
but haven't been successful to get it all into one cell and one formula.
(i.e., if not A2 then B2, if not then C2, if not then D2, if not then E2,
then stop).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top