Dear Max, I want to thank you once again for your respond and provided solutions for my problem. I m very thankful and grateful to Microsoft Office who...

I'm trying to figure out how to calculate what percentage of the retail sale price the internal cost price is? So, the internal cost is in column G, the retail...

Hi, I have this problem, What i have on hand is two column of data containing part number of two different devices. What i am trying to do is to compare this...

Formula in C3 is =IF(E3D3/12,E3,D3/12). I would like to have the cell (d3 or e3) where the data entered last control the answer in c3. -- Val

Hello, I have a formula in the cell. I want to be able to enter a number in the cell if necessary. In the event the number is "0" or erased, I would like the...

hi all, i have a problem returning a value from another cell. in sheet 1, i have: column A 'ID' : 1, 2, 3, 4, 5 column B 'S' : a, b, c, d, e column C 'C' :...

I am trying to retreive a date from one worksheet and place it on another. Most often, I can match on company name, but there are times when the company name...

I am using Excel 2000. I entered my data in a spreadsheet, and saved it as a CSV file. Now I need to change it to comma-separated values and send it in an...

Chip hasn't posted this for a while. I think it's a great idea to occassionally review it or read it for the first...

what is the symbol used to put on the first page of an Excel worksheet and it is then automatically printed on the other "tab" pages?

can we attach an image file to a excel cell ,scanned with a scanner ,like note pad comment ?I have a small database with 50-60 names and i need to save the...

i have a data that has dates that show up as 4/25/200, 4/25/2020 and 4/25/200 How do I get the year to show up as 4/25/2006 in the entire data?

I am trying to set up a spreadsheet with date headers and/or side labels, one week apart. I have tried without success. Any help gratefully...

Hello every body, i am fresh in this forum so please help me out.I have a sales report with entries that starts with customer names, data about the specific...

I would like to copy the formulas in Columns C to H to the next 15 pages, but only if there is a number supplied in Column B. If Column B is empty, I would...

In doing a hlookup I would like returned the cell contents from the left column and also left of that as in the example x y z aa ab ac 1 2 3 ...

Hi I'm trying to use the sumif function but I want to sum everything in a range that is not equal to one criteria eg apples 10 orange 10 pear 10 .. sum...

http://www.goodugle.com

I just started using the Checkbook register template and love it. Until I need to add some more rows, now the addition and subtraction feature in the Balance...

When using the File menu pull down screen I dont see the Properties options which I need in order to get to the properties dialog box.