Forum Discussion
Help with a formula
i need to get a formula for the following: Column C2 = 10 (number in block) if column D2 is less than C2 but higher than 0 it must score 0.5 (in column E2) if column D2 is 0 it must score 0 ...
=IF(D2=0, 0, IF(D2=C2, 1, IF(AND(D2<C2, D2>0), 0.5, "")))
If D2 equals 0, the result in E2 will be 0.
If D2 equals C2 (which is 10 in this case), the result in E2 will be 1.
If D2 is less than C2 but greater than 0, the result in E2 will be 0.5.
If none of the above conditions are met, E2 will be empty (""), which can be used to indicate "no score" or "not applicable."
Copy this formula down in column E for other rows as needed.
Hope this will help you.