ISBLANK

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Duke-

Yea, it works! Thanks for the help.

Duke Carey said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checking cells for part of a text string 2
IF function with value_if_true and value_if_false as equations 4
excel template for calculating trial balances and adjusting entri. 2
Formula help! 2
IF/AND Statements in Comp Calculator 15
IF Ranges 2
end result 4
Summing a range of cells based on criteria in another range 2

Back
Top