Problem with using IF for a range of cells

M

manan

Hi

I have a a range of cell lets say db5:do5. I need to check which is the
first value in this range whcih is between 80% to 120% of ae5. In cell
dp5 i need excel to return the column heading (range db4:db5) of the
cell which meets the above said condition.
i am new to excel and not familiar with excel programming. Is there a
way to get this done. Need help urgently

Thanks
Manan
 
A

Ardus Petus

I've been trying to get a solution with a single formula.

Till now, I only have a solution with a staging row in DB6:DO6 with formula:
=AND(DB5/$AE5>=0.8,DB5/$AE5<=1.2)

The final result in DP5 is given by formula:
=INDEX(DB4:DO4,1,MATCH(TRUE,DB6:DO6,0))

See example: http://cjoint.com/?fmnCEWBPcI

HTH
 
M

manan

Hi
thanks for your reply. I managed too get it done in stages. Its not
necessary to do it in one formula.
Thanks
 
Top