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


.