Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find multipule text strings within a cell | Excel Discussion (Misc queries) | |||
Formulas an easy explanation | New Users to Excel | |||
Copying Formulas from One Worksheet to Another -- Very Easy Questi | New Users to Excel | |||
linking four cell with multipule colums with other worksheet | Excel Worksheet Functions | |||
Changing a cell referance on multipule cells | Excel Worksheet Functions |