I've made an auto dart scoring sheet. In column A I have the dart score
input, in column B it auto subtracts that score from the set amount. The
problem is if I use say 301 as the start score in column A column B shows 301
thru all of row B. Is there a way to hide the 301 in column B until a score
is posted in column A?

"LCBO" wrote in message
...
I've made an auto dart scoring sheet. In column A I have the dart score
input, in column B it auto subtracts that score from the set amount. The
problem is if I use say 301 as the start score in column A column B shows
301
thru all of row B. Is there a way to hide the 301 in column B until a
score
is posted in column A?


=IF(cellvalue=301, "", yourcalculation)

"John Smith" wrote in message
...

"LCBO" wrote in message
...
I've made an auto dart scoring sheet. In column A I have the dart score
input, in column B it auto subtracts that score from the set amount. The
problem is if I use say 301 as the start score in column A column B shows
301
thru all of row B. Is there a way to hide the 301 in column B until a
score
is posted in column A?


=IF(cellvalue=301, "", yourcalculation)

Or alternately, a better way is to have scores in the relevant row of B when
you input a deduction, and nothing below, put your starting score of 301 in
cell A1 and start deducting in A2 so in cell B2 =IF(A2="", "", $A$1-A2).
Then cluck and drag the square to copy it down so in B3 =IF(A3="", "",
$A$1-A3), etc

Thanks John
I input =IF(A2="", "", $A$1-A2) into B2, 301 into A1. Put in 100 in A2 and
got 201 in B2...perfect! But when I input =IF(A3="", "", $A$1-A3) into B3 and
100 in A3 I get 201 again. It isn't subtracting from 201 which should be 101
in B3

"John Smith" wrote:


"John Smith" wrote in message
...

"LCBO" wrote in message
...
I've made an auto dart scoring sheet. In column A I have the dart score
input, in column B it auto subtracts that score from the set amount. The
problem is if I use say 301 as the start score in column A column B shows
301
thru all of row B. Is there a way to hide the 301 in column B until a
score
is posted in column A?


=IF(cellvalue=301, "", yourcalculation)

Or alternately, a better way is to have scores in the relevant row of B when
you input a deduction, and nothing below, put your starting score of 301 in
cell A1 and start deducting in A2 so in cell B2 =IF(A2="", "", $A$1-A2).
Then cluck and drag the square to copy it down so in B3 =IF(A3="", "",
$A$1-A3), etc


.

"LCBO" wrote in message
...
Thanks John
I input =IF(A2="", "", $A$1-A2) into B2, 301 into A1. Put in 100 in A2 and
got 201 in B2...perfect! But when I input =IF(A3="", "", $A$1-A3) into B3
and
100 in A3 I get 201 again. It isn't subtracting from 201 which should be
101
in B3

Yes, my mistake, remove the $ signs before the A and the 1

you can put this in B2 and copy down

=IF(A2="","",$A$1-SUM($A$2:$A2))

but i'm not sure what you want when you get to negative numbers because i don't
play darts
--


Gary Keramidas
Excel 2003


"LCBO" wrote in message
...
Thanks John
I input =IF(A2="", "", $A$1-A2) into B2, 301 into A1. Put in 100 in A2 and
got 201 in B2...perfect! But when I input =IF(A3="", "", $A$1-A3) into B3 and
100 in A3 I get 201 again. It isn't subtracting from 201 which should be 101
in B3

"John Smith" wrote:


"John Smith" wrote in message
...

"LCBO" wrote in message
...
I've made an auto dart scoring sheet. In column A I have the dart score
input, in column B it auto subtracts that score from the set amount. The
problem is if I use say 301 as the start score in column A column B shows
301
thru all of row B. Is there a way to hide the 301 in column B until a
score
is posted in column A?


=IF(cellvalue=301, "", yourcalculation)

Or alternately, a better way is to have scores in the relevant row of B when
you input a deduction, and nothing below, put your starting score of 301 in
cell A1 and start deducting in A2 so in cell B2 =IF(A2="", "", $A$1-A2).
Then cluck and drag the square to copy it down so in B3 =IF(A3="", "",
$A$1-A3), etc


.

"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
you can put this in B2 and copy down

=IF(A2="","",$A$1-SUM($A$2:$A2))

but i'm not sure what you want when you get to negative numbers because i
don't play darts

I don't think they go to negative numbers because you need an exact score to
go out, ending on a double.

Nope still didn't work John but thanks.
Gary's did and ty much for the help!!

"LCBO" wrote:

I've made an auto dart scoring sheet. In column A I have the dart score
input, in column B it auto subtracts that score from the set amount. The
problem is if I use say 301 as the start score in column A column B shows 301
thru all of row B. Is there a way to hide the 301 in column B until a score
is posted in column A?