"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