Formula to perform range of sums based on range of words

Closed
jesstopher
Posts
1
Registration date
Friday September 12, 2014
Status
Member
Last seen
September 12, 2014
- Sep 12, 2014 at 08:51 AM
HI I am trying to find a formula that will basically:

Check B2 to see if it contains the word "Fortnight" or "Month" or "Annual" and then "equal the value of A2" or "divide by 2 the value of A2" or "divide by 26 the value of A2" - respectfully.

I will then drag this down column B to copy the formula for rows 3 to 50.

Can anyone help?