Combining if statements

I'm not sure what your logic is since you did not really explain the conditions or the results (I would like the time (which is basically extracting certain characters) ...)
However, try, in E2, etc.:

Please Login or Register  to view this content.

The nested IFERROR statements are meant to return 1 if the first is false, i.e. found a match, 2 for the second, etc.
The 1..4 is returned to the CHOOSE which points to one of the four MID formulas to evaluate.

* Unmerge those cells in row three on MU tab. Use Center Across Selection formatting instead.

Note that on the original worksheet, cell E5, you have three independent IF statements separated by commas. That is not a Nested IF statement structure.

Hi protonLeah,

By "I would like the time (which is basically extracting certain characters)" what I mean is, for example in C2, it says "T 1645-1700". What I mean is I would to extract "1645" and then, depending on what is written in column D, I would like 1645 to do one of 3 things.
if Column D is a number from Column B on MU tab - I would like 1645+300 so it would come out to 1945
if Column D is a number from Column E on MU tab - I would like it left alone so it would come out to 1645
if Column D is a number from Column H on MU tab - I would like 1645-100 so it would come out to 1545

The answer you provided had 1 too many arguments but with a simple tweak, it seems to be doing exactly what I'd like it to do

maybe:

Formula:

Please Login or Register  to view this content.

concerning to #1

right, because, e.g. if in IF(ISNA(MATCH(D5,MU!B:B,0)),MID(C5,3,4),MID(C5,3,4)+300) is TRUE result will be just MID(C5,3,4) and so on. If bolded part will be FALSE result will be MID(C5,3,4)+300).
but if you want another value or not value you can change this MID(C5,3,4) (on the end of formula) to "" or 0.

edit:
or add another condition: IF(D5=0,"",your full formula) or IF(D5="","",your full formula)