Fortune Telling Collection - Fortune-telling birth date - How to use EXCEL macro command to realize automatic calculation function

How to use EXCEL macro command to realize automatic calculation function

Step 1: Create a name for the continuous weight and unit price. As shown in the figure:

Step 2: Enter the formula in B2: = if (A2

Step 3: Extend B2 formula to B6. The results are as follows: