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?
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?