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?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies