Forum Discussion
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 entered percentage.
3. Column C - formula which evaluates column B and states: = IF(B1<95%," and does not qualify for bonus."," ").
4. Column D - an IF(ISBLANK) formula set to review column C's formula output and create a statement "Fred H. did not meet productivity, and does not qualify for bonus" as the output IF appropriate. If Column C is blank, the formula in column D should return nothing. However currently it is returning the analysts name.
I assume this is because ISBLANK is reviewing C1 contents (a formula) and not just the text output of the formula in C1. Sound about right and any known way around this?
Thanks
Joe
2 Replies
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.
Thanks Sergei - that's all i needed, gave me the right direction to reframe my formulas and get them to work. Appreciate it!
