Current location - Training Enrollment Network - Mathematics courses - A math problem needs to print 2000 cards, and no one with serial number 4 is needed. The starting serial number is 000 1, so what is the final serial number? How to write formulas in Excel
A math problem needs to print 2000 cards, and no one with serial number 4 is needed. The starting serial number is 000 1, so what is the final serial number? How to write formulas in Excel
In column A, enter 1, 2, 3, ... first drop to 2000.

1. Right-click column A and set the cell format to 0000, then 1 becomes 0001; 2 will become 0002, and so on

2. Enter the formula if (is number (find ("4 ",a 1, 1)) in B 1, so that if a contains 4, b will display 0; if a does not contain 4, b will display 1.

3. Put the mouse in column B and look at the total number of column B. You can see that the total number is 1458, which means there are 1458 numbers excluding 4.

4. Columns A and B are pulled down at the same time, and the total number of columns B is 2000. At this time, the base of the A-pillar is 2772.

Related articles
  • Quanzhou mathematics examination questions in 2006
  • Many people are trying to persuade them not to take the Master of Law exam. Why?
  • Junior one math judgment questions
  • The first semester math review questions
  • 109 power letter representation
  • Is the interview pass rate of high school mathematics teaching resources high?
  • Math Yesterday Today Tomorrow Video
  • Shandong Education Press Grade 8 Volume 1 Mathematics [Shandong Education Press Grade 1 Volume 1 Final Examination Paper]
  • ... or some questions about college mathematics
  • How about watching online classes?

    • copyright 2024 Training Enrollment Network All rights reserved