入黎免費幫你砌excel表 / 教你formula (8)

mybroformy 2022-11-14 11:55:59 計號碼離散性唔好太離譜

:^(

BUT，跪求大佬幫手砌砌佢

:^(

PeterStrange 2022-11-14 11:58:42 我第一樣諗既係如果要match哂你兩個case
究竟仲有幾多個組合可以剩低

:^(

mybroformy 2022-11-14 12:03:53 數字夠多既應該仲好有多既…

:^(

PeterStrange 2022-11-14 12:29:11 最簡單應該都係抽到中為止
即係用vba loop到match先停

mybroformy 2022-11-14 13:06:01 VBA…神仙級數

:^(

跪求大佬幫手砌

:^(

PeterStrange 2022-11-14 13:07:47 其實好簡單

:^(

你用formula寫哂啲random
之後recal到你兩個條件match就得

mybroformy 2022-11-14 13:45:59 有冇教學

:^(

https://sites.google.com/site/outlierseconomics/other/ru-he-chan-sheng-sui-ji-luan-shu
睇完呢個都唔係好明點可以搞到我兩個問題

PeterStrange 2022-11-14 16:39:53 TG左你啦

雞髀餅 2022-11-14 16:41:57

:^(

兩手 2022-11-14 17:05:16 得十四頁我會建議你逐頁copy and paste 去excel處理

呢種係要用power automate黎scrap

喝半杯白開水 2022-11-15 13:06:21 hello 樓主有個好蠢嘅問題想問呀⋯⋯

我想將啲數字rounddown，之後再加埋一齊

而家好蠢咁手動
=ROUNDDOWN(B1, 0)+ROUNDDOWN(B2, 0)+ROUNDDOWN(B3, 0)+…

請問有冇一個快啲嘅方法？

:^(

PeterStrange 2022-11-15 13:14:46 sum(rounddown(b1:b....,0))

喝半杯白開水 2022-11-15 13:22:44 Thanks a lot!!!

咁如果我係要Sum of B1*4%, B3*4%, B9*4%各自嘅rounddown，仲可唔可以咁做？

PeterStrange 2022-11-15 13:25:08 不如你講清楚實際係點

喝半杯白開水 2022-11-15 13:44:56 唔好意思講得有啲模糊！

:^(

我要將A類嘅數字乘4% round down to the integer 再加埋一齊

而家我就手動咁逐個加埋

想睇下有冇快啲嘅formula

:^(

Thanks a lot

:^(

PeterStrange 2022-11-15 13:51:06 sum(rounddown(b1:b....,0)*if(a1:a... = "A",0.04,1))

喝半杯白開水 2022-11-15 13:53:01 Thanks 巴打

:^(

PeterStrange 2022-11-15 13:53:05 屌

:^(

sum(rounddown(b1:b....*if(a1:a... = "A",0.04,1),0))

PeterStrange 2022-11-15 13:53:47 寫錯，你睇番#993

當機重啟 2022-11-15 14:00:49 =SUMPRODUCT(--(A1:A10="A"),ROUNDDOWN(B1:B10*4%,0))

喝半杯白開水 2022-11-15 14:01:35

:^(

PeterStrange 2022-11-15 14:02:33 ctrl shift enter

喝半杯白開水 2022-11-15 14:04:56 ctrl shift enter 是咪加咗 { } 喺前後？
個答案變咗1647

:^(

PeterStrange 2022-11-15 14:05:22 唔岩咩？

當機重啟 2022-11-15 14:06:00 因為應該係
if(a1:a... = "A",0.04,0)