ly2012

哪位Excel大侠能设置这样一个公式样If column A=001, column D=column C*25%? 谢谢您！

niuniu1380

应该不难做到。你在主表格外，输入001， 在001 旁边输入25%， 然后在Logic Fomlar 上面直接找If， 然后按照If 的指引输入这个公式就可以，你试试，要是不行，可以把你的邮件地址告知，然后我直接把公式在Excel 做好，发给你。

ly2012

niuniu1380 发表于 2015-12-12 19:29
应该不难做到。你在主表格外，输入001， 在001 旁边输入25%， 然后在Logic Fomlar 上面直接找If， 然后按照 ...

Thank you so much niuniu1380!
Could you help solve a more complex one please?
When a random serial number, like 035, is entered in column A, in the same line column E=column C * 25%, while another number 058 is entered, column E=column C+column D?

Randolph

1. IF(A1="001",C1*0.25)
2. IF(A3="035",C3*0.25,IF(A3="058", C3+D3))

ly2012

Randolph 发表于 2015-12-14 17:53
1. IF(A1="001",C1*0.25)
2. IF(A3="035",C3*0.25,IF(A3="058", C3+D3))

Thank you very much Randoph! By now, my problem's completely cleared up.