Help to work this out......

[craig@help]

Hi there

I would be grateful for your help

I will explain but if you could see below firstly......

COLUMN AJ *::INTERNAL WORK::* COLUMN AV *::EXTERNAL WORKS::*
COLUMN AX *::OVERALL COMPLETED::*


column aj (1) 12/12/06
column av(1) (BLANK)
column ax (1) (LEAVE IT BLANK)

column aj (2) 12/12/06
column av (2) N/A
column ax (2) 12/12/06

column aj (3) (BLANK)
column av (3) (BLANK)
column ax (3) (LEAVE IT BLANK)

column aj (4) N/A
column av (4) 12/06/06
column ax (4) 12/06/06

column aj (5) 12/12/06
column av (5) 15/12/06
column ax (5) 15/12/06

ok here we go.....

in this project that im currently on ...i need to set u
formulas/function that on the column ax,(1) *internal works * a dat
has been input but not in the *external works *then in the *overal
completed *should leave it a blank..

if in line 4) *internal works *input n/a and the *external works *ha
date input then in the *overall completed *should have the date a
12/06/06



But if both *internal works *and *external works *has been completed
then in the *overall completed *need to look for the last date inpu
e.g line 5) 15/12/06.......make any sense to what im' trying t
explain?


Thanks

Craig;

 

[Adrian G]

Not sure if i've understood completely, but can you use a formula i
column ax, =if(av1="N/A",aj1,av1). If your required logic is mor
complex, can you use hidden columns to cascade the logic?
Adria