Adding a 3rd condition to "IF" formula in Excel

Hi all,

I hope some kind soul out there can help me.

I am working on a tight deadline for work, which is an excel sheet where I have managed to successfully create a formula for “if” with 2 conditions, but am struggling with adding the 3rd.

I need to work out a “Due Date” based off a “Date Raised” with a “Priority Level (Low, Medium, High)” for each entry.

Each “Priority Level” has a timeframe associated with it, which gives you the “Due Date”.

• In column A (row starting 2) I have “Date Raised”.
• I column B I have “Priority Level” (Low, Medium, High)
• Low has a due date of 42 days, Medium 28 days and High 14 days
• Column C is “Due Date” column (“Date Raised” + “Priority Level”)

As I mentioned, I have cracked the formula for 2 Priority Levels (IF/OR), but it goes pear shaped when I want a 3rd added.

If it’s not too much trouble, if you could also show me how I would go about adding a 4th and 5th (I don’t need them for this, but just in case I needed it later), I’d be most grateful.

For the record, I did try to look this up online but I couldn’t convey it in a way that a search engine recognised.

Thanks for your help with this, cheers.