u/DarkArctic88

I am trying to get tasks sorted by importance/urgency (the Eisenhower method).

Here's what I'm trying to get done.

Id like to create a formula that will autopopulate column F.

Column D options are highly, somewhat, not important, and E options are highly, somewhat, and not urgent.

That leaves 9 possible options for column F:

highly important, highly urgent,

Somewhat important, highly urgent

Not important, highly urgent

Highly important, somewhat urgent

Somewhat important, somewhat urgent..

You get the idea.

The formula reads column D and E and combines them to populate F automatically.

I figure this might be in the line of a "if then" type thing but I haven't figured how to combine them to output to one cell.