| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement Help
I have a maintenance schedule in excel split by quarter (1,2,3,4 etc). Along
the left-most column is worksite, Each quarter has a column, due on or before and date completed column. A B C D E SITE QTR1 QTR2 1 xxxx Due on/Before Completed Due on/Before Completed I have a date in Qtr1 "due on/before" column. What I want to do is, I guess it needs to be an IF statement for the date that goes in Qtr2 Due date such as: In D1... If the date in Completed Column(C1) blank, then C1 +91, else B1+91 Any Suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| how do i use contains in an if statement | Excel Worksheet Functions | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Threaded Mode
