Conditional Formula - With 2 Columns

[sly1974]

hello,

Need help with putting a conditional formula.

ColA = Purpose
ColB=Cash Out
ColC =Blank.

I need a formula that will fill Col C, if Col A and Col B is given.
Exp. If Col A= Refinance, ColB=N then ColC= Rate&Term
Exp. If Col A= Purchase, ColB=N then ColC= Purchase
Exp. If ColA = Refinance, ColB=Y then ColC= Cash Out



Purpose Cashout Blank (ColC)
Refinance N Rate&Term
Purchase N Purchase
Purchase N Purchase
Purchase N Purchase
Purchase N Purchase
Purchase N Purchase
Refinance Y Cash Out
Purchase N Purchase
Refinance N Rate&Term
Refinance Y Cash Out
Refinance Y Cash Out
Purchase N Purchase


Thanks!

[Pepe Le Mokko]

Please read the yellow banner.....

[Glenn Kennedy]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

Since you are new here, I have done it for you - THIS TIME.

https://www.mrexcel.com/board/thread...lumns.1117300/