I am trying to create a quote sheet using several cells in a string. While I
have figured out how to consult values in another workbook, I am unable to
write the formula so that it only calcuates those cells in the string that is
selected with a value. Example:

I am working on creating cashflows for my company. I have a monthly
spreadsheet and a weeekly spreadsheet. What i need to know is 'Is it possible
to have a tab for monthly and weekly with tabs inside both for the months of
the year?'

Is there a way of having it so if people select on option on a drop down list
it will only let them edit a certain drop down box later in the sheet? e.g.
If the select project risks the can only edit the drop down boxes relevant to
them and same for bottom up risks etc.

I would like to get help in creating a function to put into a cell with the
UK postal code, normally 2 letters then 1 or 2 numbers, space then 1 number
followed by 2 letters eg. WR9 9EP or WR10 3EH

How can I caculate military times such as 1800 hours to 400 hours for a time
sheet?

I currently use the following formula below to caculate the number of days
worked by each emloyee
=SUMPRODUCT(('Employee Data'!$L$5:$L$260<>"")/COUNTIF('Employee
Data'!$L$5:$L$260,'Employee Data'!$L$5:$L$260&""))

I am just trying to format a range of cells. What I need is, If we
enter a web address say, http://yahoo.com, the cell should
automatically convert it as http://www.yahoo.com.
Is it possible?. Any help is greatly appreciated.

I've got a worksheet that uses the following countif function:
{=COUNT(IF((bay.cost.1=B97)*(dept.1="DOTAG"),bay.cost.1))}
and it works, B97 is a currency value.
In another worksheet I have

I have a spreadsheet with dates and amounts in columns A and B.  I want to
retrieve the last date and amount in both columns right before the empty
cells.  The dates are in ascending order and there are spaces in some rows
and some of the amounts can be spaces or zero.

Is there a way to solve Y=((1+x)^5)/x with Y known in excell?  There is no
way to solve this algabraically that I am aware of.  
Thank You,
Frank

A1:A9
1,2,3,8,-9,0,null (i.e.=""),blank,8
I want to count the numbers (both positive and negative) but I want to exclude 0, null and blank.  Duplicates are counted more than once.
The formula I come up with is

I have a worksheet with about 55,000 line items in it regarding sales
history for the past nine months.
* Column A has part numbers.  (The same part number can appear multiple
times)

I am not sure if this question belongs to this discussion group but here it is
I have one sheet that contains all employee information
I would like to be able to type any employee ID in a seperate sheet in the
same workbook an pull all the related information listed in sheet 1

I need to write a macro that will pull all the information from one sheet and
copy the values to another one based on the Employee ID being the trigger
Other than taking a course does anyone have somethign that can do the trick
Thanks

How do I average the values in non-contiguous cells, while ignoring cells
with 0 values? I tried the average function, but the IF conditional seems to
recognize only contiguos cells. I keep getting the "The formula you entered
contains an error..." message, and cannot execute the ...