Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Formula (Date)
Hi there, hopefully someone can help, the formula below is in cell AP81 =IF(AP54=AO54,IF(AP54=AN54,IF(AP54=AM54,IF(AP54=AL 54,IF(AP54=AK54,IF(AP54=AJ54,Error,AP54+23),AP54+2 1),AP54+19),AP54+17),AP54+15),AP54+13) What the formula does is look at the 6 cells to the left and if they are the same (Dates) then makes the first cell +13 days, the next +15 days and so on. If the dates in row 54 are different then the default +13 days happens, which is how the formula is meant to work. What i want the formula to do in AP81 is the following: IF cell AP80 is greater than AP81 then AP80 + 2 days, else the formula above. thanks in advance BigH -- BigH ------------------------------------------------------------------------ BigH's Profile: http://www.excelforum.com/member.php...o&userid=34410 View this thread: http://www.excelforum.com/showthread...hreadid=541952 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Year-to-date year to date formula | Excel Worksheet Functions | |||
Value between 2 dates | Excel Worksheet Functions | |||
formula for filtering and a defaulting date | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |