Help on IF (i think)
 

I am trying to a monthly budget so to speak. For example...
I want the amount in K to go into F4 if J equals F3
F G I J
K
2 Friday Saturday Rent 06/01/09 $618.00
3 06/01/09 06/02/09 Water 06/06/09 $20.00
4 XXX XXX Gas 06/07/09 $45.00

Help on IF (i think)
 

Are you wanting the amount in K3 to go into F4 if J4 equals F3...?

If so, then in F4...
IF(J3=F3,K3,*)

Where * is what you want it to say when J3 does not equal F3.

--
-Zakhary


"Lost" wrote:

I am trying to a monthly budget so to speak. For example...
I want the amount in K to go into F4 if J equals F3
F G I J
K
2 Friday Saturday Rent 06/01/09 $618.00
3 06/01/09 06/02/09 Water 06/06/09 $20.00
4 XXX XXX Gas 06/07/09 $45.00

Help on IF (i think)
 

That works but it only limits me to one cell at a time and I would have to do
that for all items (rent, Water, gas, etc) under each day on the calander. I
have think about this in another way.

Basically what I want is if the pay date equals the calandar date than put
in the amount that is next to the pay date.

"Zakhary" wrote:

Are you wanting the amount in K3 to go into F4 if J4 equals F3...?

If so, then in F4...
IF(J3=F3,K3,*)

Where * is what you want it to say when J3 does not equal F3.

--
-Zakhary


"Lost" wrote:

I am trying to a monthly budget so to speak. For example...
I want the amount in K to go into F4 if J equals F3
F G I J
K
2 Friday Saturday Rent 06/01/09 $618.00
3 06/01/09 06/02/09 Water 06/06/09 $20.00
4 XXX XXX Gas 06/07/09 $45.00

Help on IF (i think)
 

You could simply drag the formula into (fill down) the adjacent cells.

I am assuming that, like F4 is a reference to K3, J3, and F3; F5 will
reference K4, J4, and F4...

After keying in the formula for F4, place your cursor over the bottom-right
corner of F4. The white plus symbol (+) will change to a black plus symbol.
Click and drag down through all the cells this formula is to be applied to.
Effectively,

Cell F5 will read IF(J4=F4,K4,*)
Cell F6 will read IF(J5=F5,K5,*)
and so on

Where * is what you want it to say when the J cell is not equal to the F cell.


--
-Zakhary


"Lost" wrote:

That works but it only limits me to one cell at a time and I would have to do
that for all items (rent, Water, gas, etc) under each day on the calander. I
have think about this in another way.

Basically what I want is if the pay date equals the calandar date than put
in the amount that is next to the pay date.

"Zakhary" wrote:

Are you wanting the amount in K3 to go into F4 if J4 equals F3...?

If so, then in F4...
IF(J3=F3,K3,*)

Where * is what you want it to say when J3 does not equal F3.

--
-Zakhary


"Lost" wrote:

I am trying to a monthly budget so to speak. For example...
I want the amount in K to go into F4 if J equals F3
F G I J
K
2 Friday Saturday Rent 06/01/09 $618.00
3 06/01/09 06/02/09 Water 06/06/09 $20.00
4 XXX XXX Gas 06/07/09 $45.00