ISBLANK

[Gimpy815]

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 Carey]

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?

[Gimpy815]

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?