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

"Cloud Strife" wrote:

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?

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

Now, everything in false statement...

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
---------------
Jacob Skaria


"Cloud Strife" wrote:

Now, everything in false statement...

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

"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?

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

"Cloud Strife" wrote:

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)

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?

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