ERROR - "The formula contains a number outside of the valid range"
Hello,
I am using an equation that is returning the error "the formula contains a number outside of the valid range" when the constituent cells of the equation contain a negative number. I have tried using the inspector to format the problem cell(s) differently, but to no avail. The equation works fine in other respects. How is numbers deciding what the valid range for variables in my foruma is?
I've done the math out separately to make sure the equation isn't dividing by 0 or something wacky, but there's nothing wrong with the formula or the result... It should be doing math and it's not!
I haven't found any posts by other users with the same problem.
Thanks.
Numbers '09-OTHER, Mac OS X (10.6.8)