excel按条件返回值,if语句怎么写

2024-11-25 07:18:07
推荐回答(1个)
回答1:

=if(A1<=3,A1*10,if(A1<=6,40,55))
=lookup(A1,{1,2,3,4,7},{10,20,30,40,50})