Where N24 is 1,200 and C10 is 4,791,299, I get .02 on the old mechcanical
adding machine and .02 is definitely between -.1 and.1, so I'm not sure where
the wrinkle is. Excel doesn't show an error in the formula. It just doesn't
return the correct result.
My guess is that it is good practice to use the negative sign to denote
negative numbers in formulas, as opposed to using parentheses.
Dave
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.