View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave1940
 
Posts: n/a
Default write a "if" command. day of month + remainder

In Excel I want to write a "if" command to look at one cell during the first
part of the month and another cell for the remainder of the month. For
instance I recieve my social security check into my checking account on a
seclected day of the month. I want to have the "if" command to tell me my
balance before this seclected day of the month, then have it tell me the
balance after this day of the month. I have on my spread sheet two different
cells with different balances for the "if" statement to look.