How does Excel quickly calculate the advertising cost and output performance of a website?

Source: Internet
Author: User

How does Excel quickly calculate the advertising cost and output performance of a website?

1, the first is to count out the daily advertising consumption performance results of output

2, you can also batch time period statistics, just to the corresponding time period of the value of the data to add up on it, small series is in accordance with the month, early, mid, late to set! I'm using the formula to show!

3, through me this can see B and V columns, the formula is the same, but the data is not the same! The picture is too small, may not see clearly, I handwritten this formula: =sum (B4:B6), I This is a month, =sum (B7:B16) early, This is not one of the words is a simple summation formula! Because I have too many data covered in this report, some data is hidden, I will not show you any other data!

4, focus on, input-output ratio of the formula is what? My formula is =if (v3=0, "1:0", (B3/B3) & ":" &left ((V3/B3), 3), B3 is the advertising fee, is our input, V3 is the performance, that is, what we call output!

5, we carefully look at this formula, in fact, =if () formula we can not use, but if we do not use our input ratio will show #div/0 error, as shown:

6, my formula means, if our performance is 0, then the day we input-output ratio is 1:0, otherwise the input divided into 1, because we must be 1, and then use & Merge, then output divided by input, =left () formula refers to the left to take the number of digits, The final formula is if (v3=0, "1:0", (B3/B3) & ":" &left ((V3/B3), 3), so we calculate the results of the day out, we only need to fill in the amount of daily input and output amount on it!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.