• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 456
  • Last Modified:

Why do I keep getting a error message in my formula

I am having the toughest solving this error problem in the attached exce spreadsheet.  Can a expert take a look at row 9 explain (fix) why i'm getting a error message in the on cell when i'm dragging the formula.

Thank you,


Testing.xls
0
allwork32
Asked:
allwork32
1 Solution
 
Michael FowlerSolutions ConsultantCommented:
Cell D7 was not blank. If you select the cell and press delete the formula starts working.

Michael
Testing.xls
0
 
SeanStricklandCommented:
If you run into that problem regularly, you can use the TRIM() function to catch those.

=IF(OR(ISBLANK(D7),TRIM(D7)=""),"0",SUM(C9+D7)-D4)
0
 
allwork32Author Commented:
I knew it was something simple.  Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now