nesting IF functions

[whitepaw]

I am trying to write a formula that doubles the previous number every time an adjacent cell returns a certain value i.e. "tails" (as in heads v tails) - but only to a predetermined limit (see attachment). Once the predetermined limit is reached, the formula is to return to the start point "1". I am hoping someone can assist please.

[NBVC]

You mean perhaps?

=IF(C4="heads",B$3,IF(B3>=8,2,B3*2))

copied down...

So if the previous cell contains an 8 or larger, then it will return a 2, otherwise it will multiply you previous cell by 2.


Edit:

I see now that B3 is your initial assigned value.

My formula would need a slight edit: =IF(C4="heads",B$3,IF(B3>=8,B$3*2,B3*2))

[daddylonglegs]

Try this formula in A4 copied down

=IF(OR(C4="heads",B3*2>8),B$3,B3*2)

[whitepaw]

many thanks to both NBVC & daddylonglegs for thier responses to my thread. Both solved my problem thank you. As a first time user of this forum it is great to know that there is a wealth of info out there to assist new excel users like. Hopefully I can assist someone else in turn. cheers.