View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zakhary Zakhary is offline
external usenet poster
 
Posts: 19
Default 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