Is a fix possible when using excel 2013?

[Noxqss38242]

The code for the error is:
=IFERROR([Sum of Paid Hours]-([Sum of Direct Hours]+[Sum of Indirect Hours]),"0")

The cells in question are also formatted as "General" and not number, not sure if that matters but they are all formatted the same. Works perfect with Excel 2016 but when shared with another using Excel 2013, they get that error. Is this just a version issue that 2013 can't handle or is there a fix?

 

[Alex Blakenburg]

I don't know a lot about this but can I assume you have this loaded to the Data Model ?
and if so is the Data Type the same on all 3 of these fields in the Data Model ?

 

[Noxqss38242]

Yes, all 3 columns are: Data Type: Decimal Number

 

[Noxqss38242]

Not sure if this helps as the computer/version of excel in question is operated by a guy in another state, so I can't check for fixes right away....but my formula:
=IFERROR([Sum of Paid Hours]-([Sum of Direct Hours]+[Sum of Indirect Hours]),"0")
Didn't use for error a decimal. I changed the formula to read IFERROR "0.0" instead.

Any other suggestions?

 

[RoryA]

Don't use quotes around the zero at all:

=IFERROR([Sum of Paid Hours]-([Sum of Direct Hours]+[Sum of Indirect Hours]),0)

 

[Noxqss38242]

Thank you all for assistance....RORYA for the win!