if formula

[B1G0]

Hi
Another problem for my fishing competition
The first fish from each peg counts as 2 points the rest count as 1 point.......
So what I have done is.......
=(A2*1+1) so five fish will give me a score of 6, (5*1+1) tho if on a peg that no fish are caught it will still record a score of 1 (which is my problem)

Sent from my Nexus 7 using Tapatalk

[etaf]

try
=if(A2=0,0,(A2*1+1) )

or
=if(A2=0,0,(A2+1) )

[B1G0]

Nice 1 etaf it works a treat tho how could I do that for multiple cells? As in A2 is round 1 and A3 is round 2 how could I write that as a formula?

Sent from my Nexus 5 using Tapatalk

[etaf]

exactly what did you want to do - can you give an example or add a sample spreadsheet.

I think this may help

=if(A2=0,0,(A2+1) ) + if(A3=0,0,(A3+1) ) + =if(A4=0,0,(A4+1) ) etc

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[B1G0]

Etaf your a star ;-)

Sent from my Nexus 5 using Tapatalk