![](data:image/svg+xml;utf8,<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" viewBox="0 0 72 71" width="72"></svg>)
Calculate the sum of the numbers that can be divided by 3 or 5 from 1 to 100, and display the numbers that can be divided by 3 or 5 Find the VB code, especially the sum part, urgent
Sub a() I = 1J = 1s = 0For I = 1 to 100 step 1If I mod 3 = 0 or I Mod 5 = 0 then cells (j + 1,1) = is = S + ij = j + 1end ifnext cells (1,1) = "the sum of numbers within 1 ~ 100 divisible by 3 or 5 equals" & End Sub
RELATED INFORMATIONS
- 1. How many numbers can be divisible by 7 and 5 from 1 to 100?
- 2. What are the numbers that can be divided by 2, 3 and 5 at the same time within 200?
- 3. How many numbers can be exactly divided by 3, 4 and 5 between 100 and 200?
- 4. Ask the sum of all numbers between 100 and 200 that can be divided by 5? The exam will be held tomorrow. Now there is a question with no answer. Contact me if you understand VB. There are several questions for you. Thank you very much!
- 5. A five digit number has different numbers. It can be divided by 3, 5, 7 and 11. What is the largest number in this number?
- 6. What are the maximum two digits that can be divided by 2 and 3 at the same time? What is the minimum three digits? Please! Hurry
- 7. It's all three figures! Another question: a 24 cm long, 18 cm wide rectangular paper, to be divided into small squares of equal size, and no surplus. What's the minimum score. A. 12 B. 15 C. 9 D. 6
- 8. There is a four digit number that can be divided by 2 and 5. Its first two digits are the smallest two digits that can be divided by 3. What is the odd sum of four digits If there is a four digit number that can be divided by 2 and 5, the first two digits are the smallest two digits that can be divided by 3, and the sum of the four digits is odd, what is the number?
- 9. If a three digit number can be divided by 3, just see if the sum of all digits of the number can be divided by 3. Why? Is there such a rule if a four digit number can be divided by 3?
- 10. Use the smallest prime number, the smallest odd number, the smallest sum number and zero to form a four digit number. What are the maximum four digits that can be divisible by 2 and 5 at the same time? What are the minimum four digits that can only be divisible by 2?
- 11. Within 100, the largest odd number divisible by 3 and 5 at the same time is () A. 75B. 85C. 90D. 95
- 12. For numbers within 50-100, () can be divisible by 2,3,5 at the same time
- 13. 51 times of 51 minus one is divided by 7
- 14. 1. 2, 5 and 0 can be divided by 4 and 5 at the same time?
- 15. (3 and 12, 16 and 4, 51 and 3)
- 16. What are the characteristics of numbers divisible by 7 and 13,17 Is it three paragraph sum or three paragraph alternating sum?
- 17. A number can be divisible by 96, 3 by 51 and 2 by 74. What is the maximum number of a number?
- 18. The two digits divisible by 17 are 17, 34, 51, 68 and 85, and the two digits divisible by 23 are 23, 46, 69 and 92
- 19. In 18, 27, 30, 46, 51, 65102 The number divisible by two is_________ What is the number divisible by 5_________
- 20. Find out the number from 10 to 1000 that can be divided by 2, 3 and 7 at the same time, and output