EXCL做一个判断性的表格.

问题描述：

EXCL做一个判断性的表格.
现在我想用EXCSL做一个东西：基本是这样,如果A1为“书本”时候应用公式=IF(H1=0,0,(IF(M1>100,"1.7",IF(M1>13,"1.6",IF(M1>10,"1.1",IF(M1>4,"2",IF(M1>0,"1.9","")))))))*H1.如果A1为“铅笔”的时候引用公式=IF(H1=0,0,(IF(M1>100,"1.7",IF(M1>13,"1.5",IF(M1>10,"1.1",IF(M1>4,"1.2",IF(M1>0,"1","")))))))*H1.如果为其他东西的时候就应用=IF(H1=0,0,(IF(M1>100,"1.5",IF(M1>13,"1.3",IF(M1>10,"1.1",IF(M1>4,"1",IF(M1>0,"0.9","")))))))*H1..

1个回答分类：综合 2014-10-07

问题解答：

我来补答

你既然知道用IF,那为何不用IF嵌套,来判断A1的值自动执行对应的公式呢?
再问： ��Ҫ��ô��IFǶ��ˡ��Ϻָ�㡣��ԵĻ��ܷ�ѹ�ʽ��ң�
再答： if�﷨��IF(logical_test, [value_if_true], [value_if_false]) ��ģ� IF(A1="�鱾",IF(H1=0,0,IF(M1>100,"1.7",IF(M1>13,"1.6",IF(M1>10,"1.1",IF(M1>4,"2",IF(M1>0,"1.9","")))))))*H1,IF(A1="Ǧ��",IF(H1=0,0,(IF(M1>100,"1.7",IF(M1>13,"1.5",IF(M1>10,"1.1",IF(M1>4,"1.2",IF(M1>0,"1","")))))))*H1,IF(H1=0,0,(IF(M1>100,"1.5",IF(M1>13,"1.3",IF(M1>10,"1.1",IF(M1>4,"1",IF(M1>0,"0.9","")))))))*H1))

展开全文阅读

上一页：例2的第一问

下一页：数列的证明怎样证