•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I need a formula to make 10 as 100% but 10.01 and above be 99.99% and below
Our take
To create a formula that calculates percentages based on your specifications, you'll want to establish a relationship between your actual score and the target score. You aim for an actual score of 10% to equate to 100%, while scores above 10% should gradually decrease the percentage. For example, if your actual score is 11%, you want to reflect a 90% rating. By leveraging conditional logic in your formula, you can achieve this progressive decrease. Let's explore how to formulate this effectively for your needs.
I'm creating a form that calculates the total average of actual scores with the target score, considering the target score is 100% when you the actual score is the same or higher than the target score. Got that part pretty much figured out. My problem is I need a formula to work on a lower number target. This is my current formula
My target is <10%, and when my score is 1-10%, that's 100%. but when I get 10.01% that would lessen the percentage to 99.99%. the higher the score, the lower the percentage gets. Is there a formula I can use?
EDIT: this is what i'm trying to get. B12 is at 11% so C12 should be at 90%
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to set return value no higher than a number (10%), no lower than a number (5%) but ignore zerosI have a column of values under “Total Percent” (A2-A10). In a new column (B2-B10), Trying to return the number at least 5% but no more than 10%. Currently the column A has some negative percents, that I want column B to return at least 5%. And some values say 15% that I want to cap (show) at 10%. Where the value currently has 0%, I want to leave it alone and return 0 or just leave it blank. For max 10%, I can type in column B the formula =MIN(0.10,[@Total Percent]]) and it returns 10% when column has a value of 25%. How do I amend my formula to capture the other two parameters? Thanks! submitted by /u/Crunchie04 [link] [comments]
- How to make a mathematical formula operate in the same cell in which I input a number?I have students doing an exam of 53 questions. When they tell me the score, eg. 46 out of 53 questions correct, I want to put that number into a cell, and then have it automatically convert it to a percentage in that same cell. Is there a way to do this in the same cell into which I input the number? example. in Cell B3. I put in the number 45. Excel makes a calculation of "45 divided by 53 multiplied by 100" and puts the result as a percentage in the same cell (B3) where I input the value 45, in this case 86.79%. I know how to do this using more than one cell, where the formula is put in to cell B4, which would tell excel to take the value of cell B3, apply the formula, and get the result in cell B4. I am trying to find out if I can do it inside the cell without additional cells and external cell references. Thanks! submitted by /u/22EatStreet [link] [comments]
- Problem with assessing scoresHello, could someone help me, I don't know how to write this formula. You want to assess your score. If you have 95 then write in a cell 5 (because 5-> (90, 100]) or 82 then write 4 (because 4->(80, 90]. So for example in one side you have a column full of scores next to it you want to write which mark it belongs to. Ive tried with =if function but I think I overcomplicated it. Thanks in advance submitted by /u/Particular_Salad3723 [link] [comments]
Tagged with
#AI formula generation techniques#formula generator#rows.com#Excel compatibility#Excel alternatives for data analysis#financial modeling with spreadsheets#Excel alternatives#target score#actual scores#percentage#formula#average#100%#calculation#score thresholds#99.99%#lower number target#<10%#score range#B12