Main Page 
PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Discussion
Problem with using IF for a range of cells
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Discussion
Problem with using IF for a range of cells
 |
Problem with using IF for a range of cells |
|
|
Thread Tools | Rate Thread |
12-05-2006, 11:08 AM
|
#1 |
|
Guest
Posts: n/a
|
Problem with using IF for a range of cells
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 -- manan ------------------------------------------------------------------------ manan's Profile: http://www.excelforum.com/member.ph...fo&userid=34216 View this thread: http://www.excelforum.com/showthrea...threadid=541473 |
|
|
12-05-2006, 01:29 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: Problem with using IF for a range of cells
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  O6 with formula:=AND(DB5/$AE5>=0.8,DB5/$AE5<=1.2) The final result in DP5 is given by formula: =INDEX(DB4 O4,1,MATCH(TRUE,DB6O6,0))See example: http://cjoint.com/?fmnCEWBPcI HTH -- AP "manan" <manan.27ot6p_1147425011.2086@excelforum-nospam.com> a écrit dans le message de news: manan.27ot6p_1147425011.2086@excelforum-nospam.com... > > 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 > > > -- > manan > ------------------------------------------------------------------------ > manan's Profile: > http://www.excelforum.com/member.ph...fo&userid=34216 > View this thread: http://www.excelforum.com/showthrea...threadid=541473 > |
|
|
|
12-05-2006, 03:21 PM
|
#3 |
|
Guest
Posts: n/a
|
Re: Problem with using IF for a range of cells
Hi thanks for your reply. I managed too get it done in stages. Its not necessary to do it in one formula. Thanks -- manan ------------------------------------------------------------------------ manan's Profile: http://www.excelforum.com/member.ph...fo&userid=34216 View this thread: http://www.excelforum.com/showthrea...threadid=541473 |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
