View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cloud Strife[_2_] Cloud Strife[_2_] is offline
external usenet poster
 
Posts: 14
Default Wat formula shuld i use to find the details in the cell?

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?