Running total for 2 columns IF column 3.......
What happens if G does not equal either of those choices? In this formula, it
causes the result to be 0.
=C2*E2*IF(G2="letter",1,IF(G2="tabloid",2,0)
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"paulab" wrote:
Can anyone help, I am trying to keep a running total of impressions based on
daily entries throughout the month:
If column G = "letter" than column C (sets) * column E (pages)
If column G = "tabloid" than column C (sets) * column E (pages)*2
Thank you in advance,
paulab
|