New Excel Forum
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
|
|
Unlocking the Mysteries of Excel
|
10.00 is 100% less is more than 100% more is less than 100%
2 posts
• Page 1 of 1
10.00 is 100% less is more than 100% more is less than 100%
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?
- 0
- leo
- Rookie
- Posts: 1
- Joined: Feb 4, 2016
- Reputation: 0
- Excel Version: 2010
Re: 10.00 is 100% less is more than 100% more is less than 100%
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.
- 0
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
2 posts
• Page 1 of 1
Return to General Excel Questions
Who is online
Users browsing this forum: No registered users and 120 guests