It worked for me, = 1.26
In the multiply C1 by C2 cell you must have hit the function icon and not
the equals icon.
This would Sum the two in the absence of any chosen function.
Tink.
--
View this message in context:
Am 09.07.2012 14:54, Dan wrote:
Have you formatted your C1 and C2 columns correctly?
The OP gets the #NAME error.
What is a correctly formatted cell?
Can you demonstrate us a single case where any formatting attribute has
any influence on the cell value?
--
For unsubscribe instructions
Andreas Säger wrote:
Am 09.07.2012 14:54, Dan wrote:
Have you formatted your C1 and C2 columns correctly?
The OP gets the #NAME error.
What is a correctly formatted cell?
Can you demonstrate us a single case where any formatting attribute
has any influence on the cell value?
Probably
Thanks everyone for the help. Turns out the error was due to my using a .
instead of , as decimal separator.
This works for me...
=$C4 * 0,845
... while this doesn't
=$C4 * 0.845.
--
View this message in context:
At 18:55 09/07/2012 +0200, Andreas Säger wrote:
At 08:54 09/07/2012 -0400, Dan Lewis wrote:
Have you formatted your C1 and C2 columns correctly?
The OP gets the #NAME error.
What is a correctly formatted cell?
Can you demonstrate us a single case where any
formatting attribute has any