Hi, I'm looking for a way to simplify a really loooong IF statement. In one cell, the user chooses a type of calculation. Example: 1-Prior year % to sales...

I have a column of about 1500 phone numbers (with various area codes amongst them). I now need to add the country code in front of each number. Rather than...

i have a worksheet and teh driver s will key in these information: date vehicle no km_start km_end distance travelled at the end of the month, i will do...

I want to include a formula that will drop data from worksheets that keep a running total when the data becomes over 4 weeks old. -- yardcow

Is there a way to change number with a cell range from positive to negative other than multipling it by -1

Hi, can someone please help. I have employees data regarding hours worked in a decimal format but need to convert this to show hh:mm. So that 3.5 becomes...

i need to calculate a total time times by $4.00 for example the hours are 3:50 and i need it to be multiplied by 4 any help would be...

I'm using excel for my gradebook & would like to use this function to curve scores.

This is an expression in an excel template. When I try to change the range the {} disappear and the expression doesn't work. Why are the brackets there and...

Hello How to use cells (located in a column) in formulas in a row automatically? I cannot copy the formula to other cells in the row because the coping...

I have created a workbook and need to email a single sheet of the workbook each week. Can I email a single sheet without the recipient receiving the whole...

I need to know how remove a FIX function. At the bottom right corner of my worksheet, the word FIX is present. Everything that is enetered is rounded off. ...

Hi all I'm not too familiar with Excel and was wondering if someone could please help me. I'm creating a small quiz using Excel. The questions are going to be...

I am trying to use a function to evaluate when a course is due. In column D there may or may not be a date listed. I'm using this formula in to evaluate if...

How do I clear a spreadsheet (or columns) but retain the formulas to be used over and over for different projects?

I've a cell on a worksheet whose value is selected from a drop-down list. The list contents are in a named range on another worksheet and are picked up via...

Hi there, people. Got two columns: Column "A" has (for instance) cars. (Buick, Chevy and Ford). Column B has parking lot numbers: (1,2,3,4) all in separate...

I would like to sort a pivot table by one catagory within different groups. ie Group / Sub group / Data A 1 100 2 ...

I have frequently used the Auto Filter feature with my spreadsheets. Recently I clicked the down arrow to set the criteria I wanted to use for the filter, but...

Using Excel 2002, I'm looking for help with creating an if, then formula. I have 10 conditions to check but it appears that formula won't allow me to enter...