Help using If Function

[laxminarayana]

Hello,

I am trying to automate the entry of certain text in a cell "C3" based on drop down in another cell "N16".

when i select an item from drop down , the formula works and enters text in cell "C3"

But when i again select another item from dropdown the existing text is replaced by new text.

I want the new text to be added below the existing text.

Following is the formula which i am using

=IF(N16="pay due","Payments are due from the dealer, requires special attention.",IF(N16="bill","Require bills to continue with the transaction.",""))

Please help with the changes that are to be made to the formula.

Thank You.

 

[tmhopfne]

you should send me the spreadsheet.
i can do this easily

 

[laxminarayana]

you should send me the spreadsheet.
i can do this easily

Hi,

Following is the link for the excel file

EXCEL

Thank You