Home

Using IF statement in budget

%3CLINGO-SUB%20id%3D%22lingo-sub-471749%22%20slang%3D%22en-US%22%3EUsing%20IF%20statement%20in%20budget%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-471749%22%20slang%3D%22en-US%22%3E%3CP%3E2%20part%20question.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EBackground.%26nbsp%3B%20I'm%20creating%20a%20personal%20budget%20(tried%20a%20lot%20of%20online%20ones%20and%20don't%20like%20them).%26nbsp%3B%20the%20left%20column%20is%20day%20of%20the%20month.%26nbsp%3B%20the%20next%20column%20is%20the%20bill%20or%20income%20by%20name.%26nbsp%3B%20the%20next%20column%20is%20anticipated%2C%20the%20next%20column%20is%20actual%20for%20that%20month%2C%20the%20next%20is%20for%20the%20next%20month%20and%20so%20on.%26nbsp%3B%20I've%20included%20a%20sample%20excel%20document.%26nbsp%3B%20The%20colors%20are%20for%20ease%20of%20understanding%20and%20wont%20be%20on%20the%20final%20document.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%26nbsp%3B%20I%20would%20like%20to%20use%20an%20IF%20statement%20to%20create%20a%20header%20(row%203)%20that%20shows%20how%20much%20income%20(and%20payments%20row%204)%2C%20I've%20made%20total%20for%20the%20month.%26nbsp%3B%20In%20plain%20language%3A%20if%20an%20input%20in%20column%20b%20is%20Steve%20pay%2C%20go%20across%20to%20the%20applicable%20column%20pull%20that%20number%20and%20add%20it%20to%20a%20total%20for%20the%20cell.%26nbsp%3B%20It's%20a%20monthly%20value%2C%20so%20if%20were%20in%20October%2C%20it%20would%20need%20to%20go%20to%20column%20b%20go%20down%20find%20all%20the%20entries%20that%20say%20%22Steve%20Pay%22%20then%20go%20over%20to%20the%20column%20and%20pull%20just%20the%20%22Steve%20Pay%22%20numbers%20from%20October%2C%20and%20add%20them%20all%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%26nbsp%3B%20I%20have%20a%20few%20different%20income%20sources.%26nbsp%3B%20So%20how%20could%20I%20incorporate%203%20(or%20more)%20different%20true%20statements.%26nbsp%3B%20For%20example%2C%20in%20column%20b%20it%20would%20state%20either%20Steve%20Pay%2C%20Wife%20pay%2C%20Rental%20income%2C%20Steve%20Job%202%20pay.%26nbsp%3B%20would%20this%20all%20be%20in%201%20IF%20statement%2C%20or%20would%20I%20use%20multiple%20if%20statements%20in%20the%20same%20cell%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-471749%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBudget%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Steve_Hartley
Occasional Visitor

2 part question.  

Background.  I'm creating a personal budget (tried a lot of online ones and don't like them).  the left column is day of the month.  the next column is the bill or income by name.  the next column is anticipated, the next column is actual for that month, the next is for the next month and so on.  I've included a sample excel document.  The colors are for ease of understanding and wont be on the final document.

 

1.  I would like to use an IF statement to create a header (row 3) that shows how much income (and payments row 4), I've made total for the month.  In plain language: if an input in column b is Steve pay, go across to the applicable column pull that number and add it to a total for the cell.  It's a monthly value, so if were in October, it would need to go to column b go down find all the entries that say "Steve Pay" then go over to the column and pull just the "Steve Pay" numbers from October, and add them all up.

 

2.  I have a few different income sources.  So how could I incorporate 3 (or more) different true statements.  For example, in column b it would state either Steve Pay, Wife pay, Rental income, Steve Job 2 pay.  would this all be in 1 IF statement, or would I use multiple if statements in the same cell?