Multiplying 2 columns with IF
 

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

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

Multiplying 2 columns with IF
 

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))
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"paulab" wrote:

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