如果I10大于0,就取I10的绝对值再乘以0.2,如果I10小于0,就取I10的绝对值再乘以0.1,如果I10等于0,返回逻辑值FALSE.公式可以简化为：=ABS(I10)*IF(I10>0,0.2,0.1)ABS()是取绝对值函数,()中可以是常量,单元格的引用或嵌...
=IF(I10>0,ABS(I10)*0.2,IF(I10
1个回答
相关问题
-
s=0 for i = 1 to 10 if mod(i,3)0 loop else s=s+i endif endf
-
i=0; if (a1==1) {i=i+1; } if (a2==3) {i=i+1; } if (a3==3) {i
-
If (x(0) >= 0) And (y(0) >= 0) If f(i) >= 0 Then For j = x(i
-
int i,x; for (i=1,x=1;i=10)break; if(x%2==1) { x+=5; continu
-
if((i%4==0&&i%100!=0)||i%400==0)这个程序什么意思?
-
for循环语句嵌套怎么算?For I From 1 To 9For J From 0 To 9If 10J+I=J^2-
-
if mod(i,j)=0
-
If I pass the test with good grades,I can get to 10th grade
-
英语翻译Hello,how are you?I was wondering,if I pick like 5-10 ja
-
英语翻译if (s.charAt(i) >= '0' && s.charAt(i)