Excel 題: formula 應該要點set?
a1做input
=if(a1-400<=0,"0",if (a1-400<=1200,(a1-400)*25%,if(a1-400>1200,"300")))
Excel 題: formula 應該要點set?
Excel 題: formula 應該要點set?
a1做input
=if(a1-400<=0,"0",if (a1-400<=1200,(a1-400)*25%,if(a1-400>1200,"300")))
Excel 題: formula 應該要點set?
a1做input
=if(a1-400<=0,"0",if (a1-400<=1200,(a1-400)*25%,if(a1-400>1200,"300")))
感謝各位解答既巴打
Excel 題: formula 應該要點set?
a1做input
=if(a1-400<=0,"0",if (a1-400<=1200,(a1-400)*25%,if(a1-400>1200,"300")))
感謝各位解答既巴打
用 min max 做簡單過 nested if
Excel 題: formula 應該要點set?
a1做input
=if(a1-400<=0,"0",if (a1-400<=1200,(a1-400)*25%,if(a1-400>1200,"300")))
感謝各位解答既巴打
用 min max 做簡單過 nested if
=max(0,min(300,(a1-400) *0.25))
1600蚊除返開 當奴隸要返廿六日要六十一蚊一日 咩人要比六十蚊搭車返工都唔轉工 大西北屯門返到鰂魚涌都唔洗六十蚊
Excel 題: formula 應該要點set?
a1做input
=if(a1-400<=0,"0",if (a1-400<=1200,(a1-400)*25%,if(a1-400>1200,"300")))
感謝各位解答既巴打
用 min max 做簡單過 nested if
=max(0,min(300,(a1-400) *0.25))
高手
1600蚊除返開 當奴隸要返廿六日要六十一蚊一日 咩人要比六十蚊搭車返工都唔轉工 大西北屯門返到鰂魚涌都唔洗六十蚊
Science Park, if you live in HK island
屌你老味我份工日日行街週圍去個個月車錢都唔洗$1000,邊撚個返工要答成1600
長洲返天水圍
屌你老味我份工日日行街週圍去個個月車錢都唔洗$1000,邊撚個返工要答成1600
長洲返天水圍
返機場日日A車或機鐵
樓主巧叻叻
屌你老味我份工日日行街週圍去個個月車錢都唔洗$1000,邊撚個返工要答成1600
長洲返天水圍
返機場日日A車或機鐵
本身返機場呢d工 公司一般都會有津貼啦
on9 now
https://news.now.com/home/local/player?newsId=238959
有種咪撚拎
有種咪撚拎份你份糧啊五毛狗
我有份比架
樓主巧叻叻
關你尻事