Thread: Problem with Formula (Date)
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
mr_teacher
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote