1.JPG
I'm having some trouble getting the current red box as pictured above to calculate correctly. Basically if the inputted data (Y 6.76) is less than 10 I should be in the green. Any suggestions on what type of formula to use so that whenever data is put in that is less than 10 I will get the correct percentage? The current formula in the red box cell is =IF($Y31>0,$Y31/$G31,"100%") Thank you!
Last edited by Muse83; 07-23-2013 at 02:10 PM. Reason: I made the picture easier to understand
I updated the main picture at the top so that it's a little easier to understand.
Sorry, but this is still unclear. What does 'in the green' mean? What data is less than 10 (Y31, G31, or something else)? Your current formula has no check on whether or not the data is <10, just if Y31 is >0. Do you care about that check?
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Please post a sample sheet. Pictures are nice to look at, but useless
If Y31 is 10 or less then H31 should be 100%. Anything above 10 then the percentage in H31 should start decreasing. I'm sorry if I'm not describing it clearly enough.
=if(y31<=10,1,y31/g31)
A sample sheet may help, but I'm not sure if it would since I still don't understand what you want. You need to be more explicit in describing your desired calculations. 'In the green' and 'should start decreasing' are not mathematically descriptive enough.
First off, don't quote 100%... simply change it to 1, then format that cell to a percentage.
If I'm reading it right, can you use this formula?
=IF($Y31<=10,1,$Y31/$G31)
If you want the cells to change colors, then use conditional formatting...
Thank you, while that does cause H31 to change to 100%, is there a way to make H31 start decreasing when the data inputted is over 10?Originally Posted by djapigo
What exactly do you mean by "start decreasing"? The formula will automatically compute Y31/G31 if what you input in Y31 is less than 10... try inputting different numbers in Y31 and see if that is the result that you want to see...
For example if I was to put the number 11 in Y31 I don't want H31 to become 110%. Since 11 would be over the 10 minute limit that we are trying to reach each month I would like the overall percentage (H31) to go down after 10.
If you use Pauley's or my formula, you won't get 110%... please give it a shot... enter 11 and see what you get...
What do you want H3 to look like when the input is 11, or when it's 12, or 13, or...?is there a way to make H31 start decreasing
I can literally think of an infinite amount of 'decreasing' functions as y31 increases. Here are a few:
=if(y31<=10,1,-y31)
=if(y31<=10,1,1/log10(y31))
=if(y31<=10,1,10/y31)
Do you know what you want? If so, explain it.
Thanks for your help, it seems to be working now! I apologize again for the lack of detail I provided, today was extremely
hectic and I wasn't able to spend much time at all with my description. Thank you all again for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks