View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
rjkeeler11 rjkeeler11 is offline
external usenet poster
 
Posts: 2
Default easy one - multipule formulas in one cell

I'm sure this is easy as pie for you guys -

I'm creating a boxing scorecard and Ive hit the wall. Cells b2:b13 and
c2:c13 are where the scores go. I have the following formula in c2
=if(b2=10,9,10) that will cha column c to what I want. What I'm looking for
is a second formula that will put a zero in column c when I put a zero in
column b and still adhere to the rules of the first formula when applicable.

Also, I cant figure out an autosum function that will only add the cells
with a "10" and not sum all of the 10s. So, a total of rounds won. I can get
12 with the count function but I'd like to get the cell that say 6. I cant
figure it out and I dont know how to add an exception.

I hope I explained it properly and if I was rudimentary I apologize - I
never work with excel.

Thx in advance for your time,

Keeler