Conditional Formula - With 2 Columns

[SeanLCA]

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!

 

[Fluff]

Cross posted Conditional Formula - With 2 Columns

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Fluff]

How about
=IF(A2="Refinance",IF(B2="N","Rate&Term",IF(B2="Y","Cash Out","??")),IF(AND(A2="Purchase",B2="N"),"Purchase","??"))

 

[SeanLCA]

Noted... Thanks