Question

excel多重公式条件

1.先在C列找到属于8:00~9:00时间段的单元格 2.再确认满足条件1（8:00~9:00时间段）单元格，其D列单元格值是否都小于0.016，是则返回230；否即是任意单元各＞0.016则返回0

Answer 1

如源乱信上陪皮图雹轮

Answer 2

输入
=IF(A1="W",-84,IF(A1="E",-94,IF(A1="D",-104,"")
或者输念孝入
=VLOOKUP(A1,{"W",-84;"拍铅E",-94;"袭高好D",-104},2,0)
简化为
=-84-VLOOKUP(A1,{"W",0;"E",10;"D",20},2,0)