Hi,

Can someone please help? I need to multiply quantiity by a list price
dependent upon product (column A) and currency (column C) only if B contains
"SS"

Products a, e & p have the same list price, as do currencies e & u

Column A can contain a, e, m or p
Column B can contain ss or a number of other irrelevant values
Column C can contain e, g or u
Column D is a quantity column

IF Column A = "a", "e" OR "p" AND Column B = "ss" AND Column C = "e" OR "u"
then quantity * 299, IF Column C = "g" then quantity * 199
IF Column A = "m" AND Column B = "ss" AND C = "e" or "u", Q*650, IF C="g",
Q*439

Any ideas?