Formula for condition.

[avisoft20]

Dear expert,
I am working on a table but i am fetching some issue.Table given below
A B C F

Column	CAT	TGT DIF		Condition
1	SPL	1
2	CAT-1	2	Achieved
3	CAT-2	2	Not Achieved
4	CAT-3	2
5	CAT-4	3
6	VAL	150

<tbody>
</tbody>

I am using formula is :

=IF(C1<0,$F$2,IF(C1<0,$F$2,IF(C2<0,$F$2,IF(C6>=250,"1/2%",$F$2))))

Condition :
Case -1
If C1, C2, C3, C4, C5 is greater than Zero and C6 is greater than 150 then it’s give F2 (Achieved).
Case-2
If C1, C2, C3, C4, C5 is greater than Zero and C6 is less than 150 then it’s give F3 (Not Achieved).



Thanks
Avisoft20

 

[SteveO59L]

=IF(AND(SUM(C1:C5)>0,C6>150),"Achieved","Not Achieved")

 

[Declamatory]

It seems straightforward given the conditions of case 1 and case 2 but why in your formula do you refer to "1/2%" and also if C6>250?