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!
|