I want to add a logical function to the calculated field but I don't seem able top do so - is there a limit on the functions you can use?

My son has a severe handicap with his short term memory. I have made a spread sheet so that he can do some limited work for my business. He does ok, except for...

Hello I think I need to compile a nested if. I need to set a delivery charge for anyone who meets a certain criteria such as: Delivery free for orders over...

Hi, I have a sheet with many cost codes (101,102,103... ,201,202....) which I update daily. I want to be able to automatically total each cost code into...

I am creating a ranking sheet with 20 rows. There will be a differing amount of numbers to rank. Sometimes there may only be 10 numbers to rank and sometimes...

I need to calculate the geometric average of returns on stocks. I looked at the definition of geomean and it will not work for me. I need to use this...

I need to know the highest price I have ever paid for a product. In my inventory, I update prices monthly, changing the previously recorded price. If the "new...

I have 2 sheets in this Excel spread sheet. One is called "Main" and the other "Resolve". I have already figured out a formula that I am using on the main page...

I am making column charts in Excel. Does anyone know if it is possible in Excel to setup the y error bar for each series so that it provides multiple values? I...

I am trying to parse text string cells of various lengths and seperated by spaces. I have thousands of rows of data. I can parse with break lines at the...

Hi, I table of 3 digit numeric fields, data in field can be 1-3 significant digits. I use the numbers as input to another look up that requires all 3 digits...

Good afternoon: I am fairly new on using excel I am trying to format a PMT FUCTION for a mortage payment. The interest rate is 7% years of loan life is 5 and...

Is there a way to use the name of a worksheet in a formula? I would like to use the 'if' function and have one of the criteria be the name of the...

Hello, I have a spreadsheet in Excel 2003 and have the following problem. Details. It is a protected worksheet, but the malfunction occurs whether it's...

Im trying to make a formula that places a X in a week day (Sun - Sat) when compared to 2 dates. if A1 is the date 10/05/2006 and B1 is 13/05/2006 then cell C1...

I am looking for a way for Excel to calculate stakes based on odds for a betting challenge we have at work. For example, if I have a target of getting 100...

I am trying to total the occurrences of comma delimited numbers in a column. See original post below: I have a column which has a variable number of comma...

Looking for a way to conduct a "LOOKUP" in a random array of cells, ie A1:A25, B2,B5,C2,C5 find a specific result and return a value of "X" in a specific cell.

How do you creat a drop down list of data or categories that you can select from in Ecell? Example: I have a form in excell named "Course Category" under it...