请教条件函数问题，高手请进多谢！

damao1017101

<p>1.如果（C6-F6-I6-P6-3-U6-2000）小于等于0，则W6=0， <br/>如果（C6-F6-I6-P6-3-U6-2000）大于0小于等于500，则W6=（C6-F6-I6-P6-3-U6-2000）*0.05 <br/>如果（C6-F6-I6-P6-3-U6-2000）大于500小于等于2000，则W6=（C6-F6-I6-P6-3-U6-2000）*0.1 <br/>如果（C6-F6-I6-P6-3-U6-2000）大于2000小于等于5000，则W6=（C6-F6-I6-P6-3-U6-2000）*0.15 <br/>如果（C6-F6-I6-P6-3-U6-2000）大于5000小于等于20000，则W6=（C6-F6-I6-P6-3-U6-2000）*0.2 <br/>如果（C6-F6-I6-P6-3-U6-2000）大于20000小于等于40000，则W6=（C6-F6-I6-P6-3-U6-2000）*0.25 <br/>如果（C6-F6-I6-P6-3-U6-2000）大于40000小于等于60000，则W6=（C6-F6-I6-P6-3-U6-2000）*0.30 <br/>如果（C6-F6-I6-P6-3-U6-2000）大于60000小于等于80000，则W6=（C6-F6-I6-P6-3-U6-2000）*0.35 <br/>如果（C6-F6-I6-P6-3-U6-2000）大于80000小于等于100000，则W6=（C6-F6-I6-P6-3-U6-2000）*0.40 <br/>如果（C6-F6-I6-P6-3-U6-2000）大于100000，则W6=（C6-F6-I6-P6-3-U6-2000）*0.45</p><p></p><p>2.如果C列里输入数值则E列里显示数字3 <br/>如果C列里没有数值则E列里显示0<cd></cd><cd></cd></p>

LangQueS

<p><table cellspacing="0" cellpadding="0" width="443" border="0" style="WIDTH: 332pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="443" style="WIDTH: 332pt; mso-width-source: userset; mso-width-alt: 14176;"></col></colgroup><tbody><tr height="98" style="HEIGHT: 73.5pt; mso-height-source: userset;"><td class="xl71" width="443" height="98" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 332pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 73.5pt; BACKGROUND-COLOR: transparent;"><font face="幼圆" color="#008000">欢迎新朋友！建议将问题做好Excel问题附件压缩后上传，以便顺利得到大家的解答。编辑已发贴即可补充上传附件，切勿重复发帖。(注：浏览器如果是火狐的不能上传附件)</font></td></tr><tr height="38" style="HEIGHT: 28.5pt;"><td class="xl70" height="38" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 28.5pt; BACKGROUND-COLOR: transparent;"><a href="http://club.excelhome.net/showimg.asp?BoardID=2&amp;filename=2007-10/2007102421245830625.gif" target="_blank"><span style="FONT-WEIGHT: 700; FONT-SIZE: 14pt; COLOR: #3366ff;">上传附件方法</span></a></td></tr><tr height="27" style="HEIGHT: 20.25pt;"><td class="xl70" height="27" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;"><a href="http://club.excelhome.net/showimg.asp?BoardID=91&amp;filename=2006-11/200611812261036417.gif" target="_blank"><span style="FONT-WEIGHT: 700; FONT-SIZE: 14pt; COLOR: #3366ff;">论坛搜索方法</span></a></td></tr><tr height="25" style="HEIGHT: 18.75pt;"><td class="xl70" height="25" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent;"><a href="http://club.excelhome.net/viewthread.php?tid=45649"><span style="FONT-WEIGHT: 700; FONT-SIZE: 14pt; COLOR: #3366ff;">如何发表新话题和上传附件</span></a></td></tr><tr height="25" style="HEIGHT: 18.75pt;"><td class="xl70" height="25" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent;"><a href="http://club.excelhome.net/viewthread.php?tid=176339&amp;replyID=&amp;skin=0"><span style="FONT-WEIGHT: 700; FONT-SIZE: 14pt; COLOR: #3366ff;">发帖的技巧</span></a></td></tr></tbody></table></p>

bravolhq

<p>第一个问题：</p><p>用lookup的模糊查找功能，简历辅助区域，注意临界点的设置如500，要设置一个500.0000001的数值来对应大于500的值的对应值，</p><p>&gt;0,0</p><p>0,0.05</p><p>500,0.05</p><p>500.0000001,0.1</p><p>2000,0.1</p><p>2000.0000001,0.15</p><p>......</p><p>这样设置就可以避免临界点的问题了。</p><p>第二个问题：e列公式，=if(c1="",0,3)</p>