budget worksheet help

[marie branigan]

Help: I'm a newbie.

I am working on a daily household expense worksheet. Each date is a mini-ledger with bal forward, income, expense categories, total.

I have set it up on a 4 week cycle that matches the flow of our bi-weekly income. I have the date rows set up to automatically shift based on date is first cell (A2=A1+1 etc).

I want it so also enter the name of each fixed expense (cable, ins, etc) on their due dates. I also want the amount of that expense entered.

I succeeded with the amounts using an IF formula: =IF(A1=1,1950)+IF(A2=3,150) etc.

Now I want to show the labels A1=1 return 'rent' A1=3 return 'cable' etc.

A single "if" works fine If(A1=1,"Rent")

How do I add to the formula to cover the remaining dates? Is there a way to have it return a blank if false? thanks!

[mcmahobt]

Attaching a sample workbook would be best to obtain more in-depth help.

Based on what you have posted, however, it looks like you could use a simple LOOKUP formula instead of a long IF formula. This will be more efficient. It could look like this:

Please Login or Register  to view this content.

If you want to return a blank cell if the criteria is not met, try:

Please Login or Register  to view this content.

Just as a side note, entering in "" as a TRUE/FALSE value within an IF statement will return a blank cell.