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.

write a "if" command. day of month + remainder
 

Hi Dave:

This is only a sample. Say =TODAY() is in A1 and the first cell to look at
is B1 and the other is C1.

=IF(DAY(A1)<15,B1,C1)

will return either B1 or C1 depending on whether today is past the fifteenth
of the month
--
Gary's Student


"Dave1940" wrote:

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.