CODEWITHSUNDEEP
google-sheetsformulagoogle-sheets-formula
Nicolas lr
Nicolas lr

Reputation: 1

Why is google sheet converting my percentile to a float?

Basically I have a cell that returns a percentile - say 48% - but when I make a call to that cell returning 58% in another cell, it returns 0,577380952380952. Can anybody explain to me why? I've of course checked formatting option, tried formulas such as TO_PERCENT() etc. Why in the first place is google reading it as a float is beyond me.

Upvotes: 0

Views: 763

Answers (2)

Jorge Velasco
Jorge Velasco

Reputation: 1

So I found a way to round up the source, however in my text where I put A2 &" string..." it still shows 0.57 for 58% Edit: to reiterate, I believe my issue comes from the fact that I'm using A2 & " string..."

I ran into the same problem on a string and fixed it by embedding the to_percent in a to_text in the original calculation for %.

Example: In cell A2 put "=to_text(to_percent(58/100)" instead of just "=58/100". Then in the cell containing your string, it should show as % instead of decimal.

Alternatively, you could put the whole formula in one cell:

Example:

=to_text(to_percent(58/100))&"

This is the percentage" which should produce "58% is the percentage".

Upvotes: 0

Erik Tyler
Erik Tyler

Reputation: 9355

Formatting a number doesn't change the underlying number; it only changes how you see the number.

If you want a number to "transport" without a floating decimal, you need to apply ROUND to the initial instance/formula, e.g.:

=ROUND(*initial formula*, 2)

Note: depending on your locale, the comma above may need to be exchanged for a semicolon.

Upvotes: 2

Related Questions