在Excel VBA中怎么写if函数:=IF(AND(I6>=0,I6<1),0,IF(AND(I6>20),0,IF(AND(I6<=20),500,"")))

2025-04-12 06:23:36
推荐回答(1个)
回答1:

=IIF(AND(I6>=0,I6<1),0,IF(AND(I6>20),0,IF(AND(I6<=20),500,"")))