Thread: ISBLANK
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gimpy815
 
Posts: n/a
Default ISBLANK

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?