As in the question name, i would like to fill column C with specific range of numbers, in this case it is 1 to 0,145, i found some answers in google but i always get errors, i would like to know the simplest way to do it.
I tried some other suggestions in google and on stack overflow but all doesn't work or are not for google sheets because of errors, i want to fill column C with spread of numbers with accuracy to lets say 0,00001.Screenshot_64.png
Try something like this:
or this:
Please Login or Register to view this content.
Please Login or Register to view this content.
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
it gave me this result:
Attachment 868674
i want the column with the given count range to be from 0,145 up to equal 1 but it give me from 1 to above 1, the 2nd method gave me error.
I tried also =SEQUENCE(E4;1;E3;E2/E4) and i was closer to the main goal, but the counts on the bottom are higher than 1, i want it to be equal 1. It gave me this result:
Screenshot_66.png
i want it to be 0,145 to 1 not above 1
Last edited by HelghastG75; 05-10-2024 at 09:24 AM.
Ok i asked my buddy on discord that finally went active and he told me to apply this:
=SEQUENCE(E4;1;E3;(E2-E3)/(E4-1))
and finally the result is as on the screen below:
Screenshot_67.png
Anyway big thanks for the effort!! Hope this helps others also.
ah its still not as intended to be... :D but cant be different, i have to ask is that possible to the value on the top of D column be higher than one row below? i mean if you can control non-linearity for example and make it look more logarithmically?
Last edited by HelghastG75; 05-10-2024 at 11:05 AM.
To help us to understand what you want, can you tell us what number should be in cell C2, and what number should be in cell C31.
In C2 0,145 and in C31 just 1, and the result in the D7 should be 1701 after applying logarithmic function.
Last edited by HelghastG75; 05-10-2024 at 12:44 PM.
To help us understand what you are trying to achieve, can you provide a sample file.
You can use this form to create a file for anonymous sharing:
https://docs.google.com/forms/d/e/1F...UvZ_Q/viewform
When posting the link to your sample file, just insert some spaces into the docs.google.com part of the URL so that it is not rejected by the forum posting mechanisms.
Can you provide a step by step guide? I'm noob sorry, at the end i see some 10 files and idk how to make there my ducument to be visible there also when i put the link to this document with spaces its rejected by AI mechanisms of this forum.
You can recreate this table if you want manually.
Do you have discord? Sorry for multiposting.
No, you can provide a sample file.You can recreate this table if you want manually.
I don't do personalised one-on-one support.Do you have discord? Sorry for multiposting.
Ok, here you have it:
drive.google.com/drive/folders/1JDQjj5Bzt9-6kqRNOtouYWthlFh7aPWw?usp=sharing
Where:
B2 = 24000
C2 = 0.145
D2 = B2*C2 = 3480
B7 = 10848
C7 = 0.1568030973
D7 = B7*C7 = 1701
B31 = 240
C31 = 1
D31 = B31*C31 = 240
It seems the problem you have is not an Excel or Google Sheets problem but an arithmetic problem.
Since the users of this forum are not necessarily mathematicians, i recommend you try a website focused on solving mathematical problems.
You cant just adjust linearity curve to achieve given result?
Do you know the formula for the curve?
Unfortunately not.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks