ExcelBanter - ISBLANK

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ISBLANK (https://www.excelbanter.com/excel-worksheet-functions/73754-isblank.html)

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?