C
craig@help
Hi there,
Can you help me with this one? I have been asked to “do one more piece
of work” on to the programme that I’m still currently working on.
Here we go……
Kitchen (H3)
Bathroom Full (N3)& Part (P3)
Rewire Full (V3) & Part (X3)
Central Heating Full (AD3) & Part (AF3)
Roof (AM3)
Others (AR3)
So basically in column AX is *-=H3+N3+P3+V3+X3+AD3+AF3+AM3+AR3-*
This is for if any works first start/date input, it will state that the
property is now ‘in progress’.
However the above result will come up in number so I changed it by
going via -*‘Format Cell’ > ‘Number’> ‘Custom’> “Yes”;”Yes”;”No”’*-
This will enable us to count how many those properties are in progress
and those who are not.
The rest that Ken who have helped me with recently so I will type it
out so you can see what I’m after…..
Column AJ= Internal Handover
Column AV= External Handover
Column AY = Overall Completed
=IF(UPPER(AJ3)=”N/A”,AV3,IF(UPPER(AV3)=”N/A”,AJ3,IF(AND(ISNUMBER(AJ3),ISNUMBER(AV3)),MAX(AJ3,AV3),””)))
(-*Bear in your mind, the column AY is hidden as if in either AJ and AV
is typed “N/A”, there is number comes up ’00/01/1900’*-)
So I have added another column AZ = Overall Completed
=IF(OR(AY3>0),AY3,””)
So……what I would like is that when the ‘Overall Completed’ date (Column
AZ) is inputted (via AJ + AV), is that the AX become a ‘NO’ as the
property is now completed.
Does this make sense to you?
Craig
Can you help me with this one? I have been asked to “do one more piece
of work” on to the programme that I’m still currently working on.
Here we go……
Kitchen (H3)
Bathroom Full (N3)& Part (P3)
Rewire Full (V3) & Part (X3)
Central Heating Full (AD3) & Part (AF3)
Roof (AM3)
Others (AR3)
So basically in column AX is *-=H3+N3+P3+V3+X3+AD3+AF3+AM3+AR3-*
This is for if any works first start/date input, it will state that the
property is now ‘in progress’.
However the above result will come up in number so I changed it by
going via -*‘Format Cell’ > ‘Number’> ‘Custom’> “Yes”;”Yes”;”No”’*-
This will enable us to count how many those properties are in progress
and those who are not.
The rest that Ken who have helped me with recently so I will type it
out so you can see what I’m after…..
Column AJ= Internal Handover
Column AV= External Handover
Column AY = Overall Completed
=IF(UPPER(AJ3)=”N/A”,AV3,IF(UPPER(AV3)=”N/A”,AJ3,IF(AND(ISNUMBER(AJ3),ISNUMBER(AV3)),MAX(AJ3,AV3),””)))
(-*Bear in your mind, the column AY is hidden as if in either AJ and AV
is typed “N/A”, there is number comes up ’00/01/1900’*-)
So I have added another column AZ = Overall Completed
=IF(OR(AY3>0),AY3,””)
So……what I would like is that when the ‘Overall Completed’ date (Column
AZ) is inputted (via AJ + AV), is that the AX become a ‘NO’ as the
property is now completed.
Does this make sense to you?
Craig