Cant figure out formula?

[oxicottin]

Hello, Im having trouble with a formula and need help? I havent had any
sucsess trying to explain it so I gave a link below so it can be
downloaded and looked at. What I want is in the TOTAL DAILY PERCENT PER
DAY colum to give me a total percent from the hours worked ect. delay
time divided by percent and then multiply by 100? Not sure if that is
right. If you download you will see what i mean. Thanks!!

http://www.badongo.com/file.php?file=Delay Excel
sheet__2006-02-21_Delay.xls

 

[Bernard Liengme]

I doubt anyone will download the file.
Try to give us some sample data and tell us what you want - but do not use
terms that are meaningful just to you.
<<What I want is in the TOTAL DAILY PERCENT PER DAY Colum to give me a
total percent from the hours worked ect. delay time divided by percent and
then multiply by 100? >>
You want to add a column of numbers (who cares if they are whole number, or
fractions with % on them)
You want to divide by what? (divide by 'percent' means nothing)
best wishes

 

[oxicottin]

Ok ill try to explain! I want to divide M6 through M20 by L6 through L20
and then multiply it by 100.

 

[Guest]

Try:

=(M6:M20/L6:L20)*100

HTH
Michael

 

[oxicottin]

Tried and it gives a #VALUE!

 

[Guest]

The following are error possibilities taken from the help files:

Possible causes and solutions
Entering text when the formula requires a number or a logical value, such as
TRUE or FALSE

Microsoft Excel cannot translate the text into the correct data type. Make
sure the formula or function is correct for the required operand or argument,
and that the cells that are referenced by the formula contain valid values.
For example, if cell A5 contains a number and cell A6 contains the text "Not
available", the formula =A5+A6 will return the error #VALUE!.

Entering or editing an array formula, and then pressing ENTER

Select the cell or range of cells that contains the array formula, press F2
to edit the formula, and then press CTRL+SHIFT+ENTER.

Entering a cell reference, a formula, or a function as an array constant

Make sure the array constant is not a cell reference, formula, or function.

Supplying a range to an operator or a function that requires a single value,
not a range

Change the range to a single value.
Change the range to include either the same row or the same column that
contains the formula.

Using a matrix that is not valid in one of the matrix worksheet functions

Make sure the dimensions of the matrix are correct for the matrix arguments.

Running a macro that enters a function that returns #VALUE!

Make sure the function is not using an incorrect argument.


HTH
Michael