I am trying to write this fuction for calculating annualized return
from the monthly returns I have. If I use, (1+Rm) as my range input, I
can calculate the annualized return. But when I am trying to add 1 to
monthly returns within the function and get the answer, I am getting an

I would like to design a frmua to prevent to have 4 consecutive entries
of the same name:
B4 = Peter or any name
C4 = Peter or any name

I wish to search text in A1 for the word "div".   If it is present I want
cell A6 to equal A4.   If absent, I want cell A6 to be blank.
When '=IF(FIND("div",A1),A4,"")'  is placed in cell A6 it gives '#Value'
instead of blank if A1 does not contain"div".

I have a column with the month as the full word (January or February, etc.).  
I need to translate the words to numbers in a separate column (1 or 2, etc.)  
I haven't been able to find a function that can help perform this task.  "If"
statements will not go further than 8 levels.  ...

Hello Somebody,,
  I could use some help with this one. I'm trying to create a formula using
MS Excel
because several persons will be using this file, and they should have this

On a vlookup, I am getting strange results on only 5% of the values.                   
My "Worksheet A" houses info about staff and contains some headings like:
- column A = "Resource Name"
- column H = "Resource Start Date"

How can I disable a range of cells only for them to become active depending
on the value of another specific cell?  I don't want the cells to accept any
input data unless it meets the criteria specified on another cell.  For
instance, on the 29th day of February.

I need monthly to insert new budgets into column and over write the last
month's budgets. I would like a formular or macro to do this can you help
please?

Can any one help me how to calculate Loan Payment Dates and re payment
amount using following parameters (Loan amount, rate, start date, Frequency?)
Frequency - Monthly, Weekly, Biweekly, Bimonthly
I am trying to populate data as below:

I am trying to multiply a value to a set of current data on a wor
sheet.  The value is 0.7 and the range of cells is B4:N33 for example.
Can anyone help me with this??
Thanks-

I need to find a way to email selected worksheets from a workbook as
attachments.
I've found a sharware program called PATools but I'd like a better way if it
exists.

My formula for a lottery number selector is =INT(49*RAND()) but the problem
is that sometimes it generates the same numbers two or more times.  I know
its something to do with the IF function, but can work out how to stop it.
Please Help!

I am trying to devise a form that will calculate travel expenses. Users
will input their mileometer readings (the start and end readings) in L4
and N4 respectively.In cell G4 users will input their reason for
travel, either 'Travel between sites' or another reason.