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
|