•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
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]
Want to read more?
Check out the full article on the original site
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