Hi All,



I have a worksheet from which I want to extract certain values from each row
depending whether certain condition has met or not. The details are as
follows:



1. Column N has an "IF STATEMENT FORMULA" which puts an "X" if it does
not meet the condition.

2. From each row where there is "X" in column N, I want to paste the
Values from Cell A4 and Cell Q4 in to cell X16 and Y16.

3. Cell Q4 has a negative value. When being pasted in cell Y16, I want
the values to change signs. So if there is negative value in Cell Q4 than in
Y16 they should be positive and vice versa.



Thanks for the help



Rashid

In cell("x16") put
=IF(N2="x",A4,"") -- change the case of the "x" if you need upper
case

In cell("y16") put
=IF(N2="x",Q4*-1,"") -- change the case of the "x" if you need upper
case


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=543130