Multiplying 2 columns with IF

  • Thread starter Thread starter paulab
  • Start date Start date
P

paulab

Can someone help me out with a formula?
I'm trying to get a running total of impressions from data in two columns
with a variable.
If column g=letter than mulitply column C with column E
and
If column g=tabloid multiply column C with column E *2
 
Try this:
=IF(G2="", "", IF(G2="letter", C2 * E2, IF(G2="tabloid", (C2 * E2) * 2, "")))

Or, if tabloid and letter are the only possible values, this shorter version:
=IF(G2="", "", IF(G2="letter", C2 * E2, (C2 * E2) * 2))
 
Back
Top