Nesting/combining functions into one formula

[Jewells0905]

Good Morning,

I am fairly new to all the things Excel can do. I am currently taking a course to learn more but am having the hardest time with combining multiple functions into one formula. Does anyone have any tips/tricks to remember how to do so and avoid errors? Ex if I have Column A that has either m or f for gender, and Column B has names and addresses, but all the prefixes are Ms. How would I combine substitute and IF to search column A for Ms or Mr and then correct the Ms in column B? Example below, none of these are actual people's addresses. I would assume I would need to use a formula along the lines of this, =SUBSTITUTE(B2,"Ms.",IF(A2,"f","Ms.","Mr."),2) - however it gives me an error, stating it's the wrong number of arguments. I've tried a couple of other ways as well with errors. Any help is greatly appreciated as I have not been able to find much online to help with how to order multi function formulas.

Gender	Wrong Address	Correct Address
f	Ms. Mary Smith 787 Madison Lee's Summit MO
m	Ms. Robert Johnson 3728 Hilltop Blue Springs MO
m	Ms. John Williams 8555 Aspen Lee's Summit MO
f	Ms. Linda Brown 9299 Sunrise Raytown MO

 

[Fluff]

How about

=IF(A2="f",B2,SUBSTITUTE(B2,"Ms.","Mr."))

 

[Jewells0905]

Much appreciated!

 

[Fluff]

You're welcome & thanks for the feedback.