Calculation Error
so your problem is not with this formula but rather with the one in K15...the
difference appears to be a rounding issue (K15 changes from 78.507 to 78.51
to give you 297,083 instead of 297,702)
"Dawn" wrote:
I tried that and still came up with the wrong answer. The answer should be
297,072, and I'm getting 297,083.
"Monish" wrote:
replace "*" with ","
"Dawn" wrote:
I have a formula that won't give the right answer. I have tried pretty much
everything that I can think of. From the Tools drop down, the Alt F9. Here
is my formula: =PRODUCT(K15*3784). I'm not sure if it might have something
to do with the fact that K15 also has a formula in it. Could you help me
with this?
|