GOOGLE SHEETS: convert text to number

[Shakynom]

please check this sheet and update it as i tried to configer but noavail, i try google it but was unable to resolve. in column AW i need to multiply AU*AS, but that gives me value error. please check and respond ASAP.
Link is here
https://docs.google.com/spreadsheets/d/1W2qdOklVgwP-3GUl6BeXOxvEqunVNF7USqXyiuC4qU0/edit?usp=sharing

 

[Scott Huish]

Re: convert text to number

I should point out that that is not an Excel file, It is a Google Sheets file. I'm not familiar enough with Google Sheets to offer too much advice. However, multiplying by 3,8 not 3.8 might be part of your problem.

 

[Shakynom]

Re: convert text to number

Thanks, but i used vlookup for this 3,8 as i need it as it is, the error indicates That column AS is not a numeric. Hope someone have the solution still waiting.

 

[Joe4]

Re: convert text to number

I have moved this to the "General Excel Discussion & Other Questions" forum.

In the future, when asking questions about Google Sheets, please be sure to mention that is a Google Sheets question in the title or question, and post it to this forum.

Thanks.

 

[Shakynom]

Re: convert text to number

No one here to solve this problem???

 

[Joe4]

Re: convert text to number

No one here to solve this problem???

In all fairness, this is an Excel forum, and this is a Google Sheets questions (and they are not the same thing). So this might not be the best forum to post such a question.
You might get lucky, and someone who knows Google Sheets too might stumble upon this, but might not.

 

[J.Ty.]

Re: convert text to number

I have tried to fix it, but failed.

J.Ty.