=vlookup(c7,{.00,.0;.80,.75;.90,.85;1.0,100;1.25,1 .40},2)
You may want to check out:
http://www.contextures.com/xlFunctions02.html

Format the cell to display as Percent--do not type percent values into the
formula.

You can replace the values in curly brackets with cell references. I'm using
a USA setup, so commas represent the next cell in a row. Semicolons mean
start a new row. You'll see examples on the website I referenced.

tj

"torky1" wrote:

Please help! :)
I need a formula that basically says this:
If cell C7 is less than 80%, then C8 equals 0%
If cell C7 is greater than or equal to 80%, but less than 90%, then C8
equals 75%
If cell C7 is greater than or equal to 90%, but less than 100%, then C8
equals 85%
If cell C7 is greater than or equal to 100%, but less than 125%, then C8
equals 100%
If cell C7 is greater than or equal to 125%, then C8 equals 140%

Any help would be appreciated!