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

  • Thread starter Thread starter Cloud Strife
  • Start date Start date
C

Cloud Strife

Hi, I'm currently stucked in my assignment, coz i need 2 do smtg like this.
Currently I have a cell is General Manager, so I need to use a formula to
find out manager can hav 15% deducted, so wat formula can I use?
 
Hi,

I can see that clearly English isn't your first language and as a result I'm
struggling to understand your quastion! Perhaps you could try again to
explain a bit more clearly and in particular what you decreasing by 15% and
what you have already tried.

Mike
 
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?
 
Try

=IF(ISERROR(FIND("Manager",C2)),TRUE,FALSE)
OR
=IF(ISERROR(FIND("Manager",C2)),5,15)%

If this post helps click Yes
 
Hi,

Use Search and not find because the latter is case sensitive and 'could give
problems. Try this, if the string Manager is found in C2 it multiplies C3 by
0.85

=IF(ISERROR(SEARCH("Manager",C2,1)),"",C3*0.85)

Mike
 
The below should work but as Mike mentioned it is case sensitive. You can
also try the below

=IF(C2="","",IF(COUNTIF(C2,"*manager*"),15,5))

Mike, Sorry I just logged in to find this post unanswered. Since the time
zones are different couldnt identify that you were awaiting a response from
the OP...

If this post helps click Yes
 
Hey, I tried =IF(ISERROR(SEARCH("Manager",C2,1)),True Statement, False
Statement, but end up still all True statement.

=IF(ISERROR(SEARCH("Manager",C2,1)),"",C3*0.85)

and I don't get it this part ,"",C3*0.85)
 
Hi,

The formula I gave you will look for 'Manager' in C2 and if it finds it
multiply C3 * 0.85 which is the same as reducing by 15%. What do you want to
do if it finds the text and what do you want to do if it doesn't?

Mike
 
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
 
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
 
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
 
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
 
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 said:
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.
Click to expand...


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