Hi so im trying to create a rate table so 100% is 450 how do i make it so anyone under 450 it will show how far they are from 100% and if there over 450 how much over 100% they are
Hi so im trying to create a rate table so 100% is 450 how do i make it so anyone under 450 it will show how far they are from 100% and if there over 450 how much over 100% they are
My simplistic idea, place the following in B1, then change A1 to whatever value you'd like
Formula:Please Login or Register to view this content.
This might give you somewhat of an idea of how to accomplish what you are asking.
Basically you divide the rate by 450 to get the percentage under or over 450
NOTE: Be sure to format B1 as Percentage
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
something like this?
cool thank you where can i go to learn excel and become a advanced user
youtube has a huge selection of teachers that go from the basics to advanced.
a personal favorite Leila Gharani
LBUG has a much nicer solution than mine.
As for where to learn excel, this forum is a great resource as is Google.
This link has some good info as well
http://www.rondebruin.nl/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks