|
Elite Member
|
強者我朋友自己試出來...
=IF(AND(AND(E3>=80%,I3>=80%),J3>=N3),E3*(IF($G$1="Q1",(AD3),IF($G$1="Q2",(AE3),IF($G$1="Q3",(AF3),IF($G$1="Q4",(AG3)))))),IF(AND(AND(E3>=60%,I3>=80%),J3>=N3),E3*$K$1*(IF($G$1="Q1",(AD3),IF($G$1="Q2",(AE3),IF($G$1="Q3",(AF3),IF($G$1="Q4",(AG3)))))),IF(AND(AND(E3>=80%,I3>=80%),(H3*J3)/(G3*N3)>=$N$1),(IF($G$1="Q1",(AD3),IF($G$1="Q2",(AE3),IF($G$1="Q3",(AF3),IF($G$1="Q4",(AG3))))))*($K$1*(H3*J3)/(G3*N3)),IF(AND(AND((E3>=60%)*(E3<80%),I3>=80%),(H3*J3)/(G3*N3)>=$N$1),$K$1*E3*((H3*J3)/(G3*N3))*(IF($G$1="Q1",(AD3),IF($G$1="Q2",(AE3),IF($G$1="Q3",(AF3),IF($G$1="Q4",(AG3))))))))))
=ROUND(IF($G$1<>"Q4",0,IF($G$1="Q4",IF(AND(AND(E3>=80%,I3>=80%),F3>=N3),E3*(O3+P3+Q3+R3+S3+T3+U3+V3+W3+X3+Y3+Z3),IF(AND(OR(E3<80%,I3<80%),F3<N3),0,IF(AND(AND(E3>=0.8,I3>=80%),((D3*F3)/(C3*N3)>=$N$1)),(O3+P3+Q3+R3+S3+T3+U3+V3+W3+X3+Y3+Z3)*$K$1*(D3*F3)/(C3*N3)))))),0)
__________________
https://pcdvd.com.tw/showpost.php?p=1087539637&postcount=11439
https://www.pcdvd.com.tw/showthread.php?t=1199128&page=12&pp=10
我期待的不是穴 而是有妳的洞舔
我期待的不是液 而是和妳的慾奸
我期待煙花漫天 我可以永遠不怕妳捉奸
我期待的不是一句抱歉
免費貼圖
https://home.gamer.com.tw/creationDetail.php?sn=6146343
https://www.youtube.com/watch?v=GaJ3FsfHOXE
https://www.youtube.com/shorts/WY3Jg_p8Wkk
https://www.youtube.com/watch?v=v3OF2ehgngI
https://www.youtube.com/shorts/ChnMCmPGNsY
https://www.youtube.com/watch?v=84a4Opj2aQM
https://www.youtube.com/watch?v=jYcb5D5Vrxs
https://www.youtube.com/watch?v=qkkbyiMrPTw
https://www.youtube.com/watch?v=6YAjUM77930
https://www.youtube.com/watch?v=vClBg_WMEYY
https://www.youtube.com/shorts/HiT_3SPDxG0
https://www.youtube.com/watch?v=_reqm2SGLxQ
https://www.youtube.com/shorts/JLvdp3aozxE
https://www.youtube.com/shorts/rtZ9qQ1hdwM
https://www.youtube.com/shorts/oiqHRhSmho8
https://www.youtube.com/shorts/GcsYl6xemoQ
https://www.youtube.com/shorts/UDua-34TR0g
https://www.youtube.com/watch?v=0-Fs9hdFHCE
https://www.youtube.com/watch?v=N2UL79895DM
|