Date and text movement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pasty - 23 Nov 2006 13:42 GMT

=IF(O2=P2,AND(P2,J2&" "&K2),P2)

I want my register to put a date in to a field if its done on time (there
will be a planned date already specified) and also move text from one cell
and add it onto another one to show that it has been carried out and no
longer needs actioning

Can this be done?

Reply to this Message

David Biddulph - 23 Nov 2006 17:42 GMT

You may need to explain more clearly what you are trying to do, and what is
in the various input cells.

Your function
AND(P2,J2&" "&K2)
will be confused, because AND is looking for logicals as its inputs, and at
least one of the arguments you've given it is a text string (and I guess the
other argument you've given it may be a date?).

Signature

David Biddulph

> =IF(O2=P2,AND(P2,J2&" "&K2),P2)
>
[quoted text clipped - 4 lines]
>
> Can this be done?

Reply to this Message

Pasty - 24 Nov 2006 09:33 GMT

The cells involved are a planned end date, actual end date, End date for
closed actions, open actions, closed actions, controls and a yes/no drop down
box for if actions become controls.

If the planned end date equals the actual end date and they choose yes for
the "action becomes a control" then the open action gets put added to the
"controls" text. put into the "closed actions" column and the date gets put
into a "End date for closed actions" column.

If the planned end date equals the actual end date and they choose no for
the "action becomes a control" then the open action only gets put into the
the "closed action" column along with the date which goes into the "End date
for closed actions" column

> You may need to explain more clearly what you are trying to do, and what is
> in the various input cells.
[quoted text clipped - 12 lines]
> >
> > Can this be done?

Reply to this Message

David Biddulph - 24 Nov 2006 12:59 GMT

You need to remember that one formula will put a value into one cell. It
sounds as if there are at least two cells you are trying to write into. For
each cell for which you are trying to calculate a value, decide on the
conditions and the inputs, and write the formula accordingly.

As a first guess, for your "End date for closed actions" cell, try
=IF(planned_end_date=actual_end_date,actual_end_date,"")
and for your "closed actions" cell, try
=IF(planned_end_date=actual_end_date,IF(action_becomes_a_control="Yes",open_actions&"
"&controls,open_actions),"")

Signature

David Biddulph

> The cells involved are a planned end date, actual end date, End date for
> closed actions, open actions, closed actions, controls and a yes/no drop
[quoted text clipped - 34 lines]
>> >
>> > Can this be done?

Reply to this Message