Tips for using integrated wiring quotation sheet
Comprehensive wiring quotationPreparation of:
1. Quotation tables are divided into securities quotation tables, bidding quotation tables, and product quotation tables.
2. A securities quotation is the highest purchase price or lowest bid price reported by traders in the securities market for a certain security within a certain period of time.
3. The bid quotation table is a table summarizing the prices that merchants are willing to pay when bidding for a certain project.
4. The product quotation form is a form used to briefly introduce the product price to customers before selling a certain product.
1: IF function conditional judgment
The IF function is one of the most commonly used judgment functions, which can complete either-or judgments.
The assessment score standard is 9 points. It is necessary to judge whether the assessment results in column B are qualified.
=IF(B4>=9,"qualified","unqualified")
2: Multi-condition judgment
If the department is production and the position is mainly for operations, there is a high temperature subsidy. Use the formula in column D:
=IF(AND(B2="Production",C2="Main Operator"),"Yes","No")
The Comprehensive Wiring Quotation Form is a very practical form, and most of the filling forms are for general purposes. If you happen to need to download the Comprehensive Wiring Quotation Excel form, please download it quickly.Sign-in form for large events,Parent-child activity sign-in formIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works