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.
