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

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.