Hello my friends, i am a basic Excel user, and that's why i need your help. I need a formula to do what i explained in the following picture. I called Microsoft for that :P, maybe i should't, but since i pay for it... Maybe for you is a 1 minute work, but i couldn't handle it.
Basically, the turnament takes one week. The starting points (F2) is 0, which will grow or decrease depending on the results [H2:N2], the results could be: neutral [the points remain the same (empty cell) lose (0 value in cell) which leeds to droping by 1 point of points value (F2) for each cells from H2:N2 who contains a 0 value and win (value<>0 and also <>Empty cell) which leeds to a grow by 3 for points value,F2] So:Ajutor_forum.png I hope i was clear enough, although i wait for your questions to clarify. Thanks ! :D
Bookmarks