Different types of zeros?

Preston

The formula below is creating multiple "zeros". See pictures. What am I missing?

=IF(Balance@row = "ERROR", "ERROR", IF(Balance@row = "TBD", "TBD", IF(Balance@row = "DEDUCT", "DEDUCT", ((SUM(Jan@row:Dec@row) + SUM(CHILDREN(Jan@row:Dec@row))) - (((SUM(CHILDREN([Contract Amount]@row), "Change") + ([Contract Amount]@row)) - [Invoiced Last Year]@row) - SUM(CHILDREN([Invoiced Last Year]@row), "Change"))))))

Paul Newcome

Could it be a rounding thing where 0 is displayed but the stored value is actually 0.01 or something along those lines? And then the other 0 could be a "true" zero (0.00)?

Paul Newcome

Could it be a rounding thing where 0 is displayed but the stored value is actually 0.01 or something along those lines? And then the other 0 could be a "true" zero (0.00)?

Preston

Paul,

You're a smart cookie. I like you.

I also appreciate your continued efforts to sort shenanigans like this out via this forum.

I hope you have a pleasant day!

Sincerely,

Preston

Paul Newcome

Happy to help! 👍️

If it makes you feel any better... Most of my knowledge surrounding sorting out problems/issues has come from learning the hard way. I'm surprised I don't have my own office yet simply so that my coworkers don't have to listen to me cursing my computer on a regular basis. Hahaha.

Preston

Hard way? What's that? Swearing at the computer? NEVER.🤥

Paul Newcome

🤣🤣