Forum Discussion
JoeCavasin
Apr 13, 2020Brass Contributor
Excel IF(IS) Evaluation formulas
Morning all, need to beg assistance on an IF(IS) function. Ii have four data points to combine: 1. Column A - analysts name, Fred H. for example. 2. Column B - productivity score - manually en...
SergeiBaklan
Apr 13, 2020Diamond Contributor
Joe, it's hard to say something concrete not seeing the formula. As a comment, cells in column C are never blank, formula in them returns some text or empty string. Empty string is also the text, it's not the equivalent of blank as a value.
- JoeCavasinApr 13, 2020Brass Contributor
Thanks Sergei - that's all i needed, gave me the right direction to reframe my formulas and get them to work. Appreciate it!