core

Hi I have a nested formula but I am not able to get a blank cell if none of the parameters are met? I have attached a picture and the formula is below. =IF(AND(C2<=4,D2<=4),"NUISANCE",IF(AND(C2>=5,D2<=4),"EXPLOITABLE",IF(AND(C2<=4,D2>=5),"DEVELOPMENT",IF(AND(C2>=5,D2>=5),"CORE","")))) Thank...

I work on a mac, I created a workbook that suited my needs with the help of a number of MrExcel members, I thank all of you. When the workbook was created I was using Excel, Office 2011, 6 months ago, upgraded to Excel, Office 365. Since upgrade, the workbook is very sluggish, and acts...

Hi, I have a data table as below. I wish to devise a formula to subtotal by Month (e.g. Jan 19) and Cost Type (e.g. Core) combined. For example Core Total for Jan 19 should be £4,742. Can anyone please advise a SumIf / And formula to automate this in the 2nd table below. Thanks, Neil...

Hi folks, Parts of my census is missing, for those missing parts I'm pulling in a data-point based on an identifier having a specific phrase included. The identifier could be "Core Values", "Core Values and Leadership", "Core Values and Key Objectives", "Key Objectives". Basically if one of...

Hi All I need some help with a formula if you dont mind.... Bascially I have a Sheet called "Detailed NTWK (LAN) HW Status" and within that a column called "Core Switch Model" (Cell F3:F60), next to that there is a "Core Switch Quantity"(G3:G60). Both of these columns have data validation list...

...on 1/1/year of each year Sheet1 is blank, with only formulas in cols E& F. The app flies when opening it. Now - 09/28/17, Sheet1 has 890 rows of data from cols A:F. At this point in time, the app takes too long to finish loading. By EOY, I will have 1400 rows of data filled on Sheet1...

I'm currently trying to migrate from Excel 2007 to 2013. I have a setup where one workbook (Scheduler.xlsm) calls a set of procedures in another (Core Workbook.xlsm) through automation which updates an MS Access database with dates from the Core Workbook using DAO. If I run the test in 2007 it...