Help on IF (i think)

  • Thread starter Thread starter Lost
  • Start date Start date
L

Lost

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
 
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.
 
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.
 
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.
 
Back
Top