Problem with Formula (Date)

B

BigH

Hi there,

hopefully someone can help, the formula below is in cell AP81

=IF(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)

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
 
B

Bondi

Hi,

Maybe you can try something like

=IF(AP80>AP81,AP80+2,YourFormula)

Regards,
Bondi
 
M

mr_teacher

hi,

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

=IF(AP80>IF(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),AP80+2,IF(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))

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!
 
Top