Multiplying 2 columns with IF
=IF(G2="letter",C2*E2,IF(G2="tabloid",C2*E2*2,"ans wer undefined"))
--
David Biddulph
"paulab" wrote in message
...
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
|