Multiplying 2 columns with IF

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
 
J

JBeaucaire

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
Running total for 2 columns IF column 3....... 7
Consolidation Table from Different Excel Tabs with Different Format 1
Need Help with a VBA subroutine 0
SUMIF across 2 columns. 0
If then formula with multiple cells 2
Index/match across multiple columns? 16
formula for arriving net difference 0

Top