Hi. during lockdown we have been playing progressive whist online for nearly a year now. I've decided to record scores on a spreadsheet so all can see on zoom. i have managed to do a basic formula below, however there are some tweaks to it that i can't seem to resolve. Probably really simple but i am a beginner here. i have three columns basically, Bid, won and score. lets say columns A, B and C. Column A will contain the bid, values 0 to 7. B will show what they actually achieved, values 0 to 7 also. if the values match, column C should show a sum of 10 plus 2 points for every trick, i.e. call 2 win 2 points are 10+(2*2)=14 points. this needs to then be added to the value above in c to give running score. My formula does that, however if I add a 0 to a cell in A, and the adjacent cell in B is blank, the number 10 appears in the C column. i need to tell it to only do the calculation if both of the cells A and B have a number in it. if the two scores dont match then only the running score above is entered. Also if i dont want any figure at all to appear in the c column until the calculation is done, how do i show that.
The formula i did is =IF(L8=K8,(M7+10+(2*K8)),M7) assuming the cells im using are L, K and M
thanks
alan
The formula i did is =IF(L8=K8,(M7+10+(2*K8)),M7) assuming the cells im using are L, K and M
thanks
alan