I am using Google spreadsheet from google docs online. I have a text like 1.12345 in Cell C7, and I want to convert it into floating point value for using in below formula. The rest of the cells already contain whole numbers

C5 * C6 / C8 * value(C7)

Here, I am probably using the wrong function as value is not working, I am getting error saying that - VALUE parameter '1.12345' cannot be parsed to a number.

Which function should be used here for converting C7 cell value to a floating point value. Thanks,

CodePudding user response：

try like this:

=C5 * C6 / C8 * SUBSTITUTE(C7; "."; ",")