I have a formula in cell F9: =IF(D9=C9,"","NOT EQUAL"). It's working great.
Now I want a formula in the next column that will compute a percentage if
"NOT EQUAL" is returned by the first formula. I'm trying to use
=IF(ISBLANK(F9),"",IF("NOT EQUAL",((D9/C9)-100%)). It's not working. Help?

1) Since you have a formula in F9, ISBLANK(F9) will always be FALSE. Use
=IF(F9="",
2) Your second IF is wrong because you are testing if the text value "NOT
EQUAL" is TRUE, which it isn't. This IF should be IF(F9="NOT EQUAL"


By the way, since the only possiblle values for F9 are "" and "NOT EQUAL",
you don't need both IFs


"Gimpy815" wrote:

I have a formula in cell F9: =IF(D9=C9,"","NOT EQUAL"). It's working great.
Now I want a formula in the next column that will compute a percentage if
"NOT EQUAL" is returned by the first formula. I'm trying to use
=IF(ISBLANK(F9),"",IF("NOT EQUAL",((D9/C9)-100%)). It's not working. Help?

Duke-

Yea, it works! Thanks for the help.

"Duke Carey" wrote:

1) Since you have a formula in F9, ISBLANK(F9) will always be FALSE. Use
=IF(F9="",
2) Your second IF is wrong because you are testing if the text value "NOT
EQUAL" is TRUE, which it isn't. This IF should be IF(F9="NOT EQUAL"


By the way, since the only possiblle values for F9 are "" and "NOT EQUAL",
you don't need both IFs


"Gimpy815" wrote:

I have a formula in cell F9: =IF(D9=C9,"","NOT EQUAL"). It's working great.
Now I want a formula in the next column that will compute a percentage if
"NOT EQUAL" is returned by the first formula. I'm trying to use
=IF(ISBLANK(F9),"",IF("NOT EQUAL",((D9/C9)-100%)). It's not working. Help?