Will Nested If work??

[mgm05267]

Hi There...

I have data like this

Excel Workbook
	A	B	C	D	E	F	G	H
2						Present Date		7-Jun-12
3		Estimated		Baseline		Actual		Difference
4		Start	End	Start	End	Start	Completion
5	UT	2-Jun-12	15-Jun-12	13-Jun-12	22-Jun-12	14-Jun-12	23-Jun-12	Delayed
6	IT	3-Jun-12	20-Jun-12	5-Jul-12	22-Jun-12			Yet to Start
Sheet1

Following is the calculation

Excel Workbook
	J	K	L	M
3	Estimated		Actual
4	Start	End	Start	End
5	13-Jun-12	22-Jun-12	14-Jun-12	23-Jun-12
6	5-Jul-12	22-Jun-12
Sheet1

Excel Workbook
	N	O
5	14-Jun-12	23-Jun-12
6	Yet to Start	Yet to Close
Sheet1

Excel Workbook
	S
3	Yet to Start
4	Delayed
5	Completed
6	In Progress
7	Yet to Close
Sheet1

Is this possible to bring all these calculations to a single cell H5..

Hope am clear... please let me know for more clarification...

Please help...

 

[Rajan_Verma]

Hi,
would be better to understand if you can send file link after upload the file on any site

well.. nested if always works

Rajan.