Formula based on column

[caritx]

If Column A has data then column b gets the formula.

Column A
(Value)
M

Column B (Formula it should add) =IF(A2="M","Mr.",IF(A2="F",""))



If column B has data then column A gets the formula:

Column B (Has Data) Mr.

Column A (Formula it should add) =IF(B2="Mr.","M",IF(B2="","",IF(B2="Dr.","","F")))

If both have data ignore.
Column A (has value) M

Column B (has value) Mr.


I appreciate any help you can provide!

 

[Scott Huish]

It will take VBA to put formulas in automatically.
But your first formula does not have a False condition for the second IF.

But why not use either VLOOKUPS or ORs when appropriate.

 

[caritx]

Oh sorry yes I meant to say I need to plug this into my vba.