Hi
Need help with the below formula. What went wrong with the below formula
=IF(E21=0,0,IF(AND(E21>0,E21<50)5,IF(AND(E21>50,E21<=70),10,IF(AND(E21>=70),15))))
Below is the range for E21 cell :
-------------------------------
up to 50% - 5 points ( i.e b/w 0 to 50 )
50 to 70 % - 10 points
70 % + - 15 points"
Note: if the value is less then 0 then I need the cell updated with "0"
Error : Formula parse error.
Bookmarks