0

I have a little problem using Google Sheets. I'm using importrange to get raw data from another sheet that I don't own. This is the sample raw data, then import it my own sheet here.

Importing data doesn't cause problems. However, whenever I am computing the score (using the MIN function) the output is not accurate with the imported data and when manually inputted the score, the output is correct. Please see the arrows with the examples.

Your feedback on this will be appreciated.

  • Please add the formulas and sample data to the question it's self as well the address to the cells having the formulas that you want that we look to. Also explain whit is regexextract tag included on this question. – Rubén Mar 21 at 14:41
0

You can either convert percentual output from a query to the number or add *100 as a correction:

=MIN(120%,(REGEXEXTRACT(TO_TEXT(C6),"\d+.\d+")/0.9))*10%
=MIN(120%,((C6*100)/0.9))*10%

  • Hi guys, this is a follow-up. I'm just wondering. I tried to enter manual score below 100.00%, however, it still gave the maximum score of 12%. Also, aside from that, I tried to lower score but still get the 12%. Please help me! :( – Ben Mar 17 at 4:59
  • @Ben edit your question and include exactly what you want to accomplish by explaining how you want to calculate what and where and add some examples of desired output. – user0 Mar 21 at 2:04
  • If you notice on the cell C5 was entered manually and the result was right it should be the maximum of 12% however, when I manually enter a score that is less than by 100% (with REGEXEXTRACT(TO_TEXT() formula) it still gives the same result of 12%. Please see comparison result between C8 and C9 to their converted score. In addition, this is the thing that I want to accomplished. – Ben Mar 21 at 3:52
  • --The sheet will automatically compute the scores using the query function as the basis of their scores. – Ben Mar 21 at 4:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.