I have been trying to figure this out for a good while, but just cant get it. I have no idea what I've done wrong in this formula.
I think that it is a nested IF
formula but it still says entered too many arguments for this function
.
=IF(C12={0,1,2,3,4,5},"0","", IF(C12={6,7,8},"25","", IF(C12={9,10},"30","", IF(C12>10,"35",""))))
Can someone please tell me what i'm doing wrong here?
Edit: Thanks to @timotree my original problem is solved. But now a new one has arose, now that the cells are correctly showing what i want them to automatically it seems i cannot sum them together. For example this formula is used in cells E12-E21, i want to total these cells in E22. But as it is now i am only getting 0 even if cells E12-E21 are populated with values from 25-35.
Edit 2: 2nd problem solved again by @timotree, thanks to everyone else for helping as well.