You're very welcome. Thanks for the feedback; it's nice to know it works
for you.

Regards


"torky1" wrote in message
...
That's exactly what I was looking for! Thank you! I was headed in the
right
direction, but was haviing problems with the placement of the parentheses.

"Trevor Shuttleworth" wrote:

One way:

=IF(C7=125%,140%,IF(C7=100%,100%,IF(C7=90%,85%, IF(C7=80%,75%,0))))

Regards

Trevor


"torky1" wrote in message
...
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!