I need on help on Excel formula for if function.
I am working on transferring data from one file to another template and i would like to use the "=IF(B17="done","Completed","In-Process")" to identify if there is a word "Done" in the cell then it will populate as Completed or if there is date in the cell it should show "In-Process". I am success on this but when i move to #16-#22 if there is no data fill out for it. It still show as In-process.
Is there anyway to include formula to tell excel that if there is no data it should leave the cell blank.
Note status in column B is exact automatic exact from another file.
一种方法是嵌套两个 if 语句:
=IF(B17="","",IF(B17="done","Completed","In-Process"))
英文:如果 B17 为空,则返回空白,否则如果 B17 =“完成”,则返回“已完成”,否则返回“进行中”
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)