problem with Value error

Copper Contributor

H everyone 

first of all, sorry if my  english is not as accurate as it should be. Its not my mother tongue.

I have some simple problem with an spredsheet.

 

I just need to multiply values in different cells but its appear the value error.

silly problem, but its driving me crazy.

 

both are numbers.

They are in number format.

I dont know how to fix it 

 

Any help is appreciated

 

 

8 Replies

@MR_WONDERFUL 

Please check the cells with ISNUMBER() or ISTEXT().

 

i have used
It gives me FALSE
also, I have noticed that the formulas are appering me in another language.
How to change this?

Thanks

@MR_WONDERFUL 

You may use 1,23 instead of 1.23, etc. Other words texts. Format doesn't matter if you apply it to text value.

@MR_WONDERFUL 

Perhaps you may share screenshot to illustrate? 

as you can see #Valor# problem. I dont know how to fix it. Thanks in advance.

@MR_WONDERFUL 

I believe you have texts, not numbers as values. Try to enter in B11

=ISTEXT(B10)