Home  >  Article  >  Software Tutorial  >  How to use Excel spreadsheet to get results from calculation formulas with notes

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

PHPz
PHPzforward
2024-04-17 13:31:011039browse

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

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

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

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

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!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete