View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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