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,