How does an Excel table get a result with a formula and a note?

Source: Internet
Author: User

In the construction industry, cost personnel often use Excel tables to calculate the formula, but many people do not know how to make the calculation formula results and with notes, I'll explain the following

1, open the Excel table, ctrl+f3 pop-up name manager Click New pop-up below figure, according to the map to write name WW, the reference location written on =iferror (EVALUATE (substitute substitute (Engineering quantity calculation)! F6, "[", "*istext" ("["), "]", "]" ")", "")

Pay attention to the calculation of the amount of work! is my worksheet, F6 is a relative reference, and for the calculated formula position, this position can be modified

2, then return to the table, in the F6 position fill in your calculation formula after the number can be marked with parentheses, E6 position =ww can come to the answer, as shown in the following figure

Note : For more wonderful tutorials, please pay attention to the triple graphics tutorial channel,

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.