在表格中, 想搜索出60的倍数加18怎么做
- 提问者网友：焚苦与心
- 2021-01-30 00:16
- 五星知识达人网友：西岸风
- 2021-01-30 01:40
在B列输入公式=IF(AND(A1<>0,MOD(A1,60)=0),A1+18,
- 1楼网友：执傲
- 2021-01-30 02:20
1π:3.14 2π:6.28 3π:9.42 4π:12.56 5π:15.7 6π:18.84 7π:21.98 8π:25.12 9π:28.26 10π:31.4 11π:34.54 12π:37.68 13π:40.82 14π:43.96 15π:47.1 16π:50.24 17π:53.38 18π:56.52 19π:59.66 20π:62.8 21π:65.94 22π:69.08 23π:72.22 24π:75.36 25π:78.5 26π:81.64 27π:84.78 28π:87.92 29π:91.06 30π:94.2 31π:97.34 32π:100.48 33π:103.62 34π:106.76 35π:109.9 36π:113.04 37π:116.18 38π:119.32 39π:122.46 40π:125.6 41π:128.74 42π:131.88 43π:135.02 44π:138.16 45π:141.3 46π:144.44 47π:147.58 48π:150.72 49π:153.86 50π:157 51π:160.14 52π:163.28 53π:166.42 54π:169.56 55π:172.7 56π:175.84 57π:178.98 58π:182.12 59π:185.26 60π:188.4 61π:191.54 62π:194.68 63π:197.82 64π:200.96 65π:204.1 66π:207.24 67π:210.38 68π:213.52 69π:216.66 70π:219.8 71π:222.94 72π:226.08 73π:229.22 74π:232.36 75π:235.5 76π:238.64 77π:241.78 78π:244.92 79π:248.06 80π:251.2 81π:254.34 82π:257.48 83π:260.62 84π:263.76 85π:266.9 86π:270.04 87π:273.18 88π:276.32 89π:279.46 90π:282.6 91π:285.74 92π:288.88 93π:292.02 94π:295.16 95π:298.3 96π:301.44 97π:304.58 98π:307.72 99π:310.86 100π:314 101π:317.14 102π:320.28 103π:323.42 104π:326.56 105π:329.7 106π:332.84 107π:335.98 108π:339.12 109π:342.26 110π:345.4