Will Nested If work??

mgm05267

Well-known Member
Joined
Nov 11, 2011
Messages
615
Hi There...

I have data like this

Excel Workbook
ABCDEFGH
2Present Date7-Jun-12
3EstimatedBaselineActualDifference
4StartEndStartEndStartCompletion
5UT2-Jun-1215-Jun-1213-Jun-1222-Jun-1214-Jun-1223-Jun-12Delayed
6IT3-Jun-1220-Jun-125-Jul-1222-Jun-12Yet to Start
Sheet1



Following is the calculation

Excel Workbook
JKLM
3EstimatedActual
4StartEndStartEnd
513-Jun-1222-Jun-1214-Jun-1223-Jun-12
65-Jul-1222-Jun-12  
Sheet1




Excel Workbook
S
3Yet to Start
4Delayed
5Completed
6In Progress
7Yet 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...
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Rajan_Verma

New Member
Joined
Jul 5, 2012
Messages
13
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,518
Messages
5,596,631
Members
414,082
Latest member
sasmita

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top