How to use Excel spreadsheet to get results from calculation formulas with notes

Open the Excel table, ctrl f3 pops up the name manager, click New to pop up the picture below, write the name ww according to the picture, and write =IFERROR(EVALUATE(SUBSTITUTE(SUBSTITUTE(Engineering quantity calculation formula! F6,"[", "*ISTEXT(""["),"]","]"")")),"")

Note: Engineering quantity calculation formula! This is my worksheet. F6 is for relative reference and is the position of the calculation formula. This position can be modified

Then return to the form and fill in the F6 position Your calculation formula can be put in parentheses after the number for remarks. The answer can be obtained by placing E6=ww, as shown in the picture

The above is the detailed content of How to use Excel spreadsheet to get results from calculation formulas with notes. For more information, please follow other related articles on the PHP Chinese website!