Absolutely Clueless...

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!
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Fowmy

Well-known Member
Joined
Jul 10, 2008
Messages
512
Office Version
  1. 365
Platform
  1. Windows
Please Post your spreadsheet to explain the problem
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

For the True/False-Yes/No options you can use Data Validation. Goto Data-->Validation-->Allow-->List-->Source-->True,False or Yes,No. Now you'll have an in-cell drop-down list with those values.

If you want to post a shot of what you have now PM me your e-mail address and I'll send you the board's HTML maker.

HTH,
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
OK, I think this might be what you're after:

=SUMIF($B$3:$B$14,"Y",C$3:C$14)

HTH,
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,113
Messages
5,857,453
Members
431,880
Latest member
kar2rost

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top