JonathancM
New Member
- Joined
- Aug 4, 2010
- Messages
- 2
Hi there,
I am trying to create a really basic finances spreadsheet and require a formula for the following. The only way I can describe it is thus...
When C3 = True (I don't know what True could be, perhaps a "Y", how can I make this so?), I need C12 (my monthly remainder) to equal C2-B3.
I'd then need this formula to go all the way through C4-C11 too, all having an effect on C12, i.e. C4=Y then C12=C2-B4 etc...
I know what I have written is possible gobbledegook, but hey, we all gotta start somewhere right??
I looked at tick boxes for this purpose too (instead of "Y"), but my brain farted and I was unconscious for several days.
Any help appreciated!
I am trying to create a really basic finances spreadsheet and require a formula for the following. The only way I can describe it is thus...
When C3 = True (I don't know what True could be, perhaps a "Y", how can I make this so?), I need C12 (my monthly remainder) to equal C2-B3.
I'd then need this formula to go all the way through C4-C11 too, all having an effect on C12, i.e. C4=Y then C12=C2-B4 etc...
I know what I have written is possible gobbledegook, but hey, we all gotta start somewhere right??
I looked at tick boxes for this purpose too (instead of "Y"), but my brain farted and I was unconscious for several days.
Any help appreciated!