Hi All,
I need a formula that can include several requirements and any help would be great.
If column A = AUD, I want to check column B for "Yes" and if this is the case I want the values in E and F added together.
If column A = AUD and column B = "No" I want to add the values in F and G together.
If column A = GBP or EUR, I want to check column B for a Yes and then return the values in H and I.
If column A = GBP or EUR, I want to check column B for a "No" and then return the values in H and J.
If column A = anything other than AUD, GBP and EUR, I want to check column B for a "Yes" and then return the values in E and F and then multiply this by the value in U.
If column A = anything other than AUD, GBP and EUR, I want to check column B for a "No"and then return the values in F and G then multiply this by the value in U.
Thanks in advance.
I need a formula that can include several requirements and any help would be great.
If column A = AUD, I want to check column B for "Yes" and if this is the case I want the values in E and F added together.
If column A = AUD and column B = "No" I want to add the values in F and G together.
If column A = GBP or EUR, I want to check column B for a Yes and then return the values in H and I.
If column A = GBP or EUR, I want to check column B for a "No" and then return the values in H and J.
If column A = anything other than AUD, GBP and EUR, I want to check column B for a "Yes" and then return the values in E and F and then multiply this by the value in U.
If column A = anything other than AUD, GBP and EUR, I want to check column B for a "No"and then return the values in F and G then multiply this by the value in U.
Thanks in advance.