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

actually what I need is, to search whether in the job title whether there is
Manager or not, because if got manager i will put deduct 15% from his salary,
if not Manager it will use the false statement and the false statement will
be 5%. I need to do that, because there is a lot of employee, not all of them
is manager, so I need to do that, so when it search that in the job title
there is Manager word in it, it will use the True Statement, and if Manager
is not found in the job title it will use the false statement.

Should calculate and display the sum. Try formatting the cell to General and
edit (F2) and enter.

If this post helps click Yes
---------------
Jacob Skaria


"Cloud Strife" wrote:

Yeah, exactly, english is not my first language. Ok, I try to explain it more
detail there is a cell I've inserted General Manager for the job title, so
there is other low rank employee as well that are not Manager, so to the
manager who have take loan will deduct 15% and for those that are not manager
will deduct 5%, so now I need to do is, whether which cell got Manager this
word, will automatically deduct 15%, I've tried something like this,
=IF(ISERROR(FIND("Manager",C2,0),True statement,false statement)

C2 = General Manager

I've tried use this formula, but end up they only use the true statement,
for those that are not manager also using true statement. So any answer for
this?

Just let us know the results of the below test.

In C2 enter "General Manager". In C3 enter formula
=IF(C2="","",IF(COUNTIF(C2,"*manager*"),15,5))%

Now in C2 change that to "Receptionist" and check what is displayed in C3

If this post helps click Yes
---------------
Jacob Skaria


"Cloud Strife" wrote:

actually what I need is, to search whether in the job title whether there is
Manager or not, because if got manager i will put deduct 15% from his salary,
if not Manager it will use the false statement and the false statement will
be 5%. I need to do that, because there is a lot of employee, not all of them
is manager, so I need to do that, so when it search that in the job title
there is Manager word in it, it will use the True Statement, and if Manager
is not found in the job title it will use the false statement.

Should calculate and display the sum. Try formatting the cell to General and
edit (F2) and enter.

What you mean calculate and display the sum, but I need it in Currency...

Please ignore the post..It was meant for another thread..Mean while did you
get a chance to go through the previous posts...

In C2 enter "General Manager". In C3 enter formula
=IF(C2="","",IF(COUNTIF(C2,"*manager*"),15,5))%

Now in C2 change that to "Receptionist" and check what is displayed in C3


If this post helps click Yes
---------------
Jacob Skaria


"Cloud Strife" wrote:

Should calculate and display the sum. Try formatting the cell to General and
edit (F2) and enter.

What you mean calculate and display the sum, but I need it in Currency...

In C2 enter "General Manager". In C3 enter formula
=IF(C2="","",IF(COUNTIF(C2,"*manager*"),15,5))%

Now in C2 change that to "Receptionist" and check what is displayed in C3.

I don't get it, the whole thing..

Anyway, I uploaded my sample to this link
http://two.xthost.info/cloudstrife/Sample.xlsx

I explain again 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.

You have not yet mentioned in which cell you have the loan amount. Assuming
the loan amount in B2 and designation in C2 try the below formula in D2

=B2*IF(C2="","",IF(COUNTIF(C2,"*manager*"),0.15,0. 05))


If this post helps click Yes
---------------
Jacob Skaria


"Cloud Strife" wrote:

In C2 enter "General Manager". In C3 enter formula
=IF(C2="","",IF(COUNTIF(C2,"*manager*"),15,5))%

Now in C2 change that to "Receptionist" and check what is displayed in C3.

I don't get it, the whole thing..

Anyway, I uploaded my sample to this link
http://two.xthost.info/cloudstrife/Sample.xlsx

I explain again 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.

Nevermind, just skip that, straightly into this, that 1 is making people
confusing.

Anyway, I uploaded my sample to this link
http://two.xthost.info/cloudstrife/Sample.xlsx

I explain again 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.

Cloud Strife wrote:
Nevermind, just skip that, straightly into this, that 1 is making people
confusing.

Anyway, I uploaded my sample to this link
http://two.xthost.info/cloudstrife/Sample.xlsx

I explain again 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.


Put this in B2 and copy down to B13:

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

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?