• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • 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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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