I have use this last year, it's fine until now. the formula is now new to...

I have a spreadsheet that is calculating total cost based on the region of the country and total weight of a project that the user selects. The whole story...

I am trying to allow for multiple selections from a drop down list...how can I accomplish this? Thanks

I have an if/then formula that depending on the contents of a cell I want it to return one of 3 results. The formula works fine, except I want part of the...

would like to use drop down box for sorting. Are there any good references/illustrations to read on-line? I do not know VBA. Thank you.

I have an array of data. I want to use a lookup function to find a particular value, then produce the value directly below this reference. For example if...

hi, I have a table similar to the one below, but much longer. I would like to lookup to do this. For 500 in column C, the function will look for number...

I want to format each cell in array A(i,j) conditioned on the comparison of the value in row B(i) with a value in another array C(j), where the arrays B and...

I have a spreadsheet that I need to take the base cost of an item and add an option if it applies to that item. Example Apples = 2.00 Apples with caramel =...

I have a summary sheet and separate week number sheets. In the summary sheet I have a link to the week number sheets returning data from A1 see below. A...

I have a column that data will be entered in and I need to have a cell that will increase numerically with the number of cells that have a number in it in...

I'm looking to see if there is an alternate solution. I have end users who will enter four values. Two calculations will be performed resulting in an average...

would like to roundup this fromula to the neares whole number, is it possible =(a1/3)-20

How do I get a number in a cell rounded up without having to perform the ROUNDUP function in another cell. Mike

Hi, I have a workbook that is layed out as follows: Date Submitted / Date Expired / Date Approved / Duration Date expired = 10 working days after Date...

Our company provides quarterly employee reviews. What would be the best function to use in the following scenario: We create (re-use) a monthly spreadsheet...

I posted this question once before but the answer didn't solve my problem. I have a spreadsheet that I pulled values from a second worksheet. I was trying to...

I need a formula that will return a notification in a cell that is 1 year from the selected start date. I have an employee due a review 1 year from his start...

Can they be combined?

I'm trying to type in numbers into a cell in a previously created worksheet. The numbers are like this: 1140,21122,1111. I hadn't changed any of the...