This formula eliminates the need to create a table:
=VLOOKUP(A1,{0,0;0.8,0.75;0.9,0.85;1,1;1.25,1.4},2 )
But if you have a lot of these formulas, it would save time in the end to
create a table to use with VLOOKUP.
On Fri, 4 Mar 2005 15:35:01 -0800, 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!
|