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
|