how to enter a particular text with respect to other column

[divyateja]

Hi I m New to this.and I m very weak in this excel subject

A1 B1 C1
WITH DEPOSIT rani general
Without deposit hema deepam
Without deposit prakash deepam
Without deposit sai deepam

When ever i ll enter wìthout deposit in A1 column I have to get ''deepam " in C1 COLUMN how to arrange a formula for that plz anybody tell me....

 

[Fluff]

try in C1
=if(A1="Without deposit","deepam","")

 

[divyateja]

Hey I really thank u,I have one more doubt
If it is ''withoutdeposit" the result should be ''deepam" or if it is ''with deposit" it should be ''general " how to post a formal according to this plz tell me

 

[Fluff]

=if(A1="Without deposit","deepam",if(A1="With Deposit","General",""))