Problem with using IF for a range of cells

  • Thread starter Thread starter manan
  • Start date Start date
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
 
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
 
Hi
thanks for your reply. I managed too get it done in stages. Its not
necessary to do it in one formula.
Thanks
 

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

Similar Threads

Displaying a range based on a cell's contents 3
Can i use If to check if a cell is equal to any value in a particular range 1
Mutiply in a range of cells ? 1
Moving a bunch of data 1
Sumif with named range of nonadjacent cells. 6
Help with formula for IF ANY 1
OR statement with range of cells 5
Email Excel Cell Range using Macro 1

Back
Top