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

Problem with Formula (Date)
 

Hi,

Maybe you can try something like

=IF(AP80AP81,AP80+2,YourFormula)

Regards,
Bondi

Problem with Formula (Date)
 

Hi Bondi

this formula returns a circular reference????/



regards BigH


--
BigH
------------------------------------------------------------------------
BigH's Profile: http://www.excelforum.com/member.php...o&userid=34410
View this thread: http://www.excelforum.com/showthread...hreadid=541952

Problem with Formula (Date)
 

hi,

If you are wanting to put the formula into cell ap81 then I would think
you would need to use the formula

=IF(AP80IF(AP54=AO54,IF(AP54=AN54,IF(AP54=AM54,IF (AP54=AL54,IF(AP54=AK54,IF(AP54=AJ54,"Error",AP54+ 23),AP54+21),AP54+19),AP54+17),AP54+15),AP54+13),A P80+2,IF(AP54=AO54,IF(AP54=AN54,IF(AP54=AM54,IF(AP 54=AL54,IF(AP54=AK54,IF(AP54=AJ54,"Error",AP54+23) ,AP54+21),AP54+19),AP54+17),AP54+15),AP54+13))

Looks a bit of a monster to me though - might do the job but might also
be an easier way than this to come up with the answer!! :)

It does seem to do what you want though on my system - hope this helps!


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=541952