How do Excel tables use formulas to calculate a multiple of drop-down data?

Source: Internet
Author: User

How do Excel tables use formulas to calculate a multiple of drop-down data?

1, if the project is entered into the data, item two and its relationship is 1.5 times times, it is like we in the supermarket, said to buy the second half price, then how to enter it at this time?

2, the cursor position as shown here, enter the formula here.

3, this time we enter 1.5 times times the formula, * on behalf of multiplication (if you enter other operational symbols also apply).

4, enter, get as the figure results, the first data has been calculated.

5, this time the point has been calculated out of this data, drag down, see, is not all out of it?

6, the same, if you need to calculate other multiples of the relationship, as long as the =a2*1.5 1.5 to other multiples can be. Like 10 times times.

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.