Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VBA help
I am designing a measurement spreadsheet with the
following conditions: DESCRIPTION: For a Project, every Milestone is linked to another milestone. If Linking milestone 'ML' was completed on time, then check if this Milestone was completed on time too by comparing the number of days 'N' and the estimated number of days for Milestone 'E'. N= E "On Time" N E "Over Time" N < E "Under Time" SO IT WOULD BE SOMETHING LIKE FOR SAME PROJECT NUMBER IF ML (Actual Date of Completion) = ML (Estimated Date of completion ) THEN COMPARE N and E N= E "On Time" N E "Over Time" N < E "Under Time" Thanks in advance. Ken |
#2
|
|||
|
|||
Hi Ken
are you looking for an IF statement that says =IF(A1=B1,"On Time",IF(A1B1,"Over Time","Under Time")) where A1 has N it in and B1 has E or ??? Cheers JulieD "Ken" wrote in message ... I am designing a measurement spreadsheet with the following conditions: DESCRIPTION: For a Project, every Milestone is linked to another milestone. If Linking milestone 'ML' was completed on time, then check if this Milestone was completed on time too by comparing the number of days 'N' and the estimated number of days for Milestone 'E'. N= E "On Time" N E "Over Time" N < E "Under Time" SO IT WOULD BE SOMETHING LIKE FOR SAME PROJECT NUMBER IF ML (Actual Date of Completion) = ML (Estimated Date of completion ) THEN COMPARE N and E N= E "On Time" N E "Over Time" N < E "Under Time" Thanks in advance. Ken |
#3
|
|||
|
|||
One way:
=IF(MLAct=MLEst,CHOOSE(SIGN(N-E)+2,"Under","On","Over")&" Time","") In article , "Ken" wrote: I am designing a measurement spreadsheet with the following conditions: DESCRIPTION: For a Project, every Milestone is linked to another milestone. If Linking milestone 'ML' was completed on time, then check if this Milestone was completed on time too by comparing the number of days 'N' and the estimated number of days for Milestone 'E'. N= E "On Time" N E "Over Time" N < E "Under Time" SO IT WOULD BE SOMETHING LIKE FOR SAME PROJECT NUMBER IF ML (Actual Date of Completion) = ML (Estimated Date of completion ) THEN COMPARE N and E N= E "On Time" N E "Over Time" N < E "Under Time" Thanks in advance. Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|