Well, you've failed to quote any of the content of the message to which you
are replying, so it's a bit difficult for us to advise on the specifics, but
the main point that you've got wrong is that you seem to be expecting a
formula to "push" a value into another cell.
A formula doesn't do that; it writes the new value into the cell where the
formula is sitting.
--
David Biddulph

"Pickup" wrote in message
...
Sean, Many thanks for the reply.

Sorry my omission - the question specifies that the results of each throw
should appear in a single cell (the throws are simulated by switching auto
calc off and then using F9 to generate a new number) with running totals
being kept for the count of heads & tails.

I think you mean B2 in your examples rather than C2 .. IF(C2="Yes"... ??

I tried something like this already unfortunately when the answer's no C3
would reset to 0. I also tried

C3, =IF(B2="Yes",B3=B3+1,B3=B3)
C4, =IF(B2="No",B4=B4+1,B4=B4)

and

C3, =IF(B2="Yes",B3+1,B3)
C4, =IF(B2="No",B4+1,B4)

but this doesn't appear to put a value into B3 or B4 - it just displays a
value in C3 (presumably because it's evaulating B3=B3+1)

Thanks again

Fraser

PS I've had problems in getting Excel to place a value in a cell
referenced
in a formula before and used Macros to get round it but for this exercise
we
cannot use Macros.