| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Then Statement Clarification
This is an example of what I am trying to do
Cell A1 1/1/04 A2 12/31/04 A3 1/1/07 If A2-A1 = 1460 A3-A2 = 731 Since A2-A1 is greater than A3-A2 I want to take the difference from 1460-731 (729) and add that to 1/1/04 to make a new date of 12/31/02 but if the difference between A2-A1 and A3-A2 is negative, I want to return A3 as the date. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| What statement to use? | Excel Worksheet Functions | |||
| How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
Threaded Mode
