formula !!!!

[Rashid]

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

 

[bgeier]

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