| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
easy one - multipule formulas in one cell
Hi
Just prefix our exisitng formula with another IF statement, to look as follows: =IF(B2=0,0,IF(B2=10,9,10)). As for your second question, you want to add all the 10's, but then get 6 iso 12? What criteria to use? -- HTH Kassie Replace xxx with hotmail "rjkeeler11" wrote: 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
easy one - multipule formulas in one cell
Plse do not double post! See the reply in General quesitons
-- HTH Kassie Replace xxx with hotmail "rjkeeler11" wrote: 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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
easy one - multipule formulas in one cell
Don't be silly, the man did not double post! :-)
-- HTH Kassie Replace xxx with hotmail "Kassie" wrote: Plse do not double post! See the reply in General quesitons -- HTH Kassie Replace xxx with hotmail "rjkeeler11" wrote: 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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
easy one - multipule formulas in one cell
To count only the cells with a 10. In C14 enter:
=COUNTIF(C2:C13,"=10") Hope this helps "Kassie" wrote: Hi Just prefix our exisitng formula with another IF statement, to look as follows: =IF(B2=0,0,IF(B2=10,9,10)). As for your second question, you want to add all the 10's, but then get 6 iso 12? What criteria to use? -- HTH Kassie Replace xxx with hotmail "rjkeeler11" wrote: 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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
easy one - multipule formulas in one cell
THANKS A TON !!! Thank you to both Ron@Buy and kassie. You two must use some
type of wizard magic!! Take care, Keeler "Kassie" wrote: Don't be silly, the man did not double post! :-) -- HTH Kassie Replace xxx with hotmail "Kassie" wrote: Plse do not double post! See the reply in General quesitons -- HTH Kassie Replace xxx with hotmail "rjkeeler11" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
