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

IsError and "-"

Hello, I am not sure what the "-" means in the below?  I think it has something to do with negative numbers?  


=IF(ISERROR(('Financial Statements'!D55-'Financial Statements'!D54)/'Financial Statements'!D54),"-",('Financial Statements'!D55-'Financial Statements'!D54)/'Financial Statements'!D54)

thank you
0
pdvsa
Asked:
pdvsa
  • 2
1 Solution
 
pdvsaProject financeAuthor Commented:
Many times the number in D54 is negative and I am not sure if the "-" is somehow taking this into account?  It could have nothign to do with negative numbers though.  


thank you
0
 
FostWareCommented:
The "-" is the second parameter in the IF function. If the first query returns a Error or Divide By 0 error, it'll print a "-" instead of the error message.
0
 
pdvsaProject financeAuthor Commented:
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

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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