How the WPS table uses the IF formula

steps for the WPS table using the IF formula:

The WPS table uses the IF formula step one, opens the statistical tables, the goods kind different, the valuation method is different, has the car number, the ton number, the kilometer, the cubic meter.

WPS table using the IF formula Step two, take "car" as an example, in the P4 cell according to "=if", such as figure, if the pricing method according to the "car" price, the formula is set to j4= "car", the amount is the number of cars * unit price, that is, "K4*o4", the brackets over, enter, in the way of pricing J4 fill the car The amount is 500.

Second, continue to edit the "ton", double click cell P4, in brackets in the car's pricing formula after adding "," if j4= "ton", the price is a ton number * unit price, M4*o4, after the last bracket. Enter can, the valuation way to fill in tons, the amount is 55.2*100 product, 5520.