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

Running total for 2 columns IF column 3....... 7
Excel and mutiple criteria 4
Index/match across multiple columns? 19
VBA- IF statement to replace cell contents 0
Totaling with "IF" 1
Formula help...=IF? 1
Leave Blank If No Data 6
Excel Countifs/Sumproduct with mutil Or statement 3

Top