Formulas, Functions, Formatting, Charts, Data Analysis, etc.
by leo » Thu Feb 04, 2016 7:15 pm
Hello I have a weird request. So here is what I can tell you about this problem we have a system that if we reach 10.00 that is 100% if it falls below that then it is greater than 100% if it is greater than 10.00 then it would be lower than 100%. Is there a formula to do in excel that can figure this out or not really?
-
leo
- Rookie
-
- Posts: 1
- Joined: Feb 4, 2016
- Reputation: 0
- Excel Version: 2010
by Beamer » Fri Feb 05, 2016 10:19 am
Will this work? you would need to modify the range I'm guessing, but maybe it's a start.
You do not have the required permissions to view the files attached to this post.
-
Beamer
- Excel Junkie
-
- Posts: 217
- Joined: Oct 3, 2014
- Location: New South Wales, Australia
- Reputation: 31
- Excel Version: 2010
Return to General Excel Questions
Who is online
Users browsing this forum: No registered users and 264 guests