Wat formula shuld i use to find the details in the cell?

[Glenn]

Put this in B2 and copy down to B13:
=IF(ISERROR(FIND("Manager",A2)),C2*$F$2,C2*$F$3)

Yeah, I put this, but it came out opposite, i mean like the answer should be
in true statement, then it came out answer of false statement, and for the
false statement, it came out true statement, how come?

If that is the case, then just swap the two results. I only "corrected" your
existing formula, didn't check for the correct answer.

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

 

[Cloud Strife]

Yeah, I like to do that, but this is my assignment, lecturer will check our
formula whether it is correct or not, I tried this, I like to do like that
also, but it is not allowed.

 

[Cloud Strife]

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~

 

[Glenn]

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.

 

[Cloud Strife]

I tried your method it worked out in my sample but it doesn't work out on my
actual workbook, I uploaded my actual workbook.

http://two.xthost.info/cloudstrife/Assignment.xls

I used the same method as your formula gave, but it came out all true
statement include those should be in false.

 

[Glenn]

I tried your method it worked out in my sample but it doesn't work out on my
actual workbook, I uploaded my actual workbook.

http://two.xthost.info/cloudstrife/Assignment.xls

I used the same method as your formula gave, but it came out all true
statement include those should be in false.

Try harder. You are making the same mistakes that I corrected previously.