Cloud Strife wrote:
I uploaded my sample to this link
http://two.xthost.info/cloudstrife/Sample.xlsx

What I want, based on the sample, I want to know whether
they are manager or not, so based on their job title, there will be something
like general manager and so on, so I want excel to detect whether the cell in
column a has manager this word, then it will use the 15% X the loan amount,
and if there is no manager word in the job title, it will use 5% X the loan
amount. This is what I need.

Hope there is some reply and got the answer as soon as possible. Thank You~


My corrected formula from yesterday appears to be valid.



In your sample you have the following in B2:

=IF(ISERROR(FIND(Manager,A2,)),C2*$F$2,C2*$F$3)


You are missing the quote marks (") around Manager and have reversed the
results. Change B2 to this:

=IF(ISERROR(FIND("Manager",A2)),C2*$F$3,C2*$F$2)


Copy that formula down through B13.