Multiple Queries

[Excel_77]

Hi All,

I was wondering how to carry out the below query

If column W has a yes value and column AE contains "AUD", I want the formula to return the value in AJ, however if it's a "No" in column "W" and AE contains "AUD" I want the value in AP returned.

However if the value in column AE contains anything other than "AUD," and column w has a "Yes" value I wan the query to multiply the value in AD by 1.3, otherwise if the value is a no I want the value in AE to be multiplied by 1.3.

Is this possible and if so how?

 

[peterhinton]

hey,

can you put some sample data up showing all possible outcomes ?

 

[Norie]

Perhaps

=IF(AE2="AUD", IF(W2="Yes", AJ2, AP2), IF(W2="Yes", AD2*1.3, AE2*1.3))

 

[Excel_77]

hey,

can you put some sample data up showing all possible outcomes ?

Certainly.

W = Yes
AE = AUD

If this is true return the value in AJ.

W = No
AE = AUD

If this is true return the value in AP.

W = Yes
AE = Anything other than "AUD".

If this is true then I want the value in AD*1.3

W = No
AE = Anything other than "AUD".

If this is true I want AE*1.3

 

[Tetra201]

W = No
AE = Anything other than "AUD".

If this is true I want AE*1.3

Could you please verify that this is correct?