Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Share write protection fails | Excel Discussion (Misc queries) | |||
How to correctly write a cross-sheet "IF" formula in Excel | Excel Worksheet Functions | |||
4 and 5 week months | Excel Discussion (Misc queries) | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
Month Year Date Format | Excel Worksheet Functions |