up vote 0 down vote favorite
share [g+] share [fb]

I don't have a clue what happened. Excel stopt calculating.

The only thing i did was applying a filter, which is not active anymore.

This is an example

value R76 = 200

value H76 = =R76*1,06

Outcome = #value! Beats me

link|improve this question
79% accept rate
feedback

2 Answers

up vote 1 down vote accepted

I notice that your percentage(?) value has a decimal comma rather than a decimal point.

Have you changed the language on your spreadsheet so that it's now expecting a decimal point?

link|improve this answer
your answer brought me to the sollution. The prices I import from a csv file are for example 112.95, when I changed it to 112,95 it started calculating again. – Chris Dec 27 '09 at 15:56
feedback
up vote 0 down vote

try 1.06 instead of 1,06

link|improve this answer
when I do that, the formula stays on H76 (=R2*1.06) – Chris Dec 27 '09 at 15:50
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.