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!