CODEWITHSUNDEEP
google-sheetslocalizationspreadsheetnumber-formattingsubstitution
XMarshall
XMarshall

Reputation: 971

Converting Google sheet Cell text value to a floating point value

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,

Upvotes: 3

Views: 6236

Answers (1)

player0
player0

Reputation: 1

try like this:

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

Upvotes: 4

Related Questions