Hello. I've completed 2 Excel courses on Udemy and partway through an advanced course.

I am attempting to automate a text result based on selected options.

I appreciate any help please as I am banging my head against a wall with no Google/Youtube luck.

Document attached - Automation ApprenticeEligibilityMaster.xlsx

**Column B will always have a cell entry

1.

Column A is the manually entered output.

Based on selected options for columns B to I

I need an automated output K2 to be identical to A2

My formula is utilising IF and IFS.

I am stuck on if there is no answer in the cell.

TRUE = Before 1 Jan 2014

FALSE = After 1 Jan 2014

Not TRUE or FALSE (cell is empty) – I need A2 to only show a space “ “ as an answer.

Can anyone please help me?

2.

My other issue is spacing. You will see in my formula I use &””& in between each formula.

If C2 is entered as 4 years.

Excel will display 1st year4years

If I enter &” ”&

Excel will display 1st year 4years

If C2 is blank with no entry. With B2 entry and D2 entry with &” ”& then the displayed result will be

1st year After 1 Jan 2014 – so a double spacing between year and After.

Can anyone please help me?

Or even show me a better way or formulas I can use to get an automated column A answer based B to I.

Advanced appreciation and thank you for any help

I am attempting to automate a text result based on selected options.

I appreciate any help please as I am banging my head against a wall with no Google/Youtube luck.

Document attached - Automation ApprenticeEligibilityMaster.xlsx

**Column B will always have a cell entry

1.

Column A is the manually entered output.

Based on selected options for columns B to I

I need an automated output K2 to be identical to A2

My formula is utilising IF and IFS.

I am stuck on if there is no answer in the cell.

TRUE = Before 1 Jan 2014

FALSE = After 1 Jan 2014

Not TRUE or FALSE (cell is empty) – I need A2 to only show a space “ “ as an answer.

Can anyone please help me?

2.

My other issue is spacing. You will see in my formula I use &””& in between each formula.

If C2 is entered as 4 years.

Excel will display 1st year4years

If I enter &” ”&

Excel will display 1st year 4years

If C2 is blank with no entry. With B2 entry and D2 entry with &” ”& then the displayed result will be

1st year After 1 Jan 2014 – so a double spacing between year and After.

Can anyone please help me?

Or even show me a better way or formulas I can use to get an automated column A answer based B to I.

Advanced appreciation and thank you for any help