ok, so if 78.5104 is correct for your stiuation, then you are correctly
getting 297,083.
This would mean that perhaps the problem is in how you came up with
3,784...was that rounded perhaps? there is a difference between 3,783.995
and 3783.855...I would check the source for this number

"Dawn" wrote:

Not sure, if I pull the decimal out to 4 spaces, the number in K15 is
78.5104, which is correct for the problem.

"Monish" wrote:

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?