It's because your value actually is negative. It's something like -0.00002,
which Excel rounds to (0.00). Change your formula to round the result to two
decimal places.
You asked the same question 3 hours earlier and got an answer within 6
minutes. Please don't start a new thread on the same question.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.