View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Calculation Error

You could use this formula:

=k15*3784

But you'll want to select K15,
hit F2, then F9 and note what's in the formula bar
then hit the escape key to revert back to the formula.
(Or hit edit|Undo if you hit enter.)

And do make sure that calculation is set to automatic
(tools|Options|calculation tab)

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?


--

Dave Peterson