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

  • Thread starter Thread starter Cloud Strife
  • Start date Start date
Cloud said:
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?
Click to expand...

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)
 
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.
 
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~
 
Cloud said:
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~
Click to expand...


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.
 
Back
Top