I need to know how to create a formula for the following
D3 x 38.46 = 153.84
substract 153.84 from E3 (which will = 953.04)
953.04 x 20% will equal my answer

I have Excel 2000.  Can I set up my columns and rows in inches?

Yesterday I coloured / shaded cells in a worksheet and closed the file.  When
I reopened it today, I could not see any of the colouring / shading.  I know
that the colouring / shading is there because, whan I copy and paste the
worksheet into Word, there they are.

I have created and saved several macros (called Macro 1, Macro 2 etc.) when i
bring up a new file (on a different day) to use that macro I can't find it.
How do i located an what i call an existing macro.
If i select new macro it goes to macro #7, which kind of tells me that ...

I know two ways to do a simple shade-every-other-row format in Excel 2003
(either use the preset "List 1" under AutoFormat, or select each row
individually that you want to shade). Does it work the same way in Excel
2007? If not, how do you do it? Thanks!

How can I drag a word file name into Excel and have a shortcut link created?
I can drag the Word filename from My Recent Documents onto the desktop or
into another folder and a shortcut link is created. I would like to be able
to do this into a cell in Excel and have a shortcut ...

Is it possible to have a formula behind a checkbox that will then be able to
be calculated at the end of a row.
For example I am attempting to set up a school register, so that a child
attends a tick is selected in the checkbox, this then means that a fee is

I have created a scatter diagram chart in Excel 2007.  When I overwrite the
source data, populating the cells with new data, the chart does not update.  
I have found the only way to change the chart is to delete all data series
and re-create them.  Is there a better way?

I created a work book with Multiple sheet tabs. When I numerically
personalize each tab I will not start in order of, example  1,2,3,4..... but
start with 15,7,3,12.... can I get these tabs to  Automatically go in order
as I numerically personalize  each sheet tab???

i'm working with excel 2007.
i set in the excel option, the option "save files in format" with the value
"excel 97-2003 workbook(.xls)".
but still, when i create a new file via macro, and use the following:

when I import a csv text file to a selected range of cells that have merged
columns the cells become unmerged. How do you fix that

I am doing a math project due tomorrow and I have data from rolling two dice
fifty times.  I have a left die and right die column.  Trying to use
"if-then" statements to count different outcomes (i.e., product is over 20,
sum is 5, left die is odd, both dice are equal, etc) Any ...

I am creating a form for hiring cutlery for my local village hall (a
charity). I need to ensure that hirers only order cutlery in multiples of 10.
How can I validate their input so that if they enter eg 33 it is
automatically rounded up to 40?

I'm wondering if the record limit has been changed in Excel 2007.
Thanks all for answering

I have one column in excel sheet filled in dates from 1/1/2007 till 31/12/2007
in second column sales figures for each date
I want a formula to sum all sales figures in June only moth or August month
Please help