formula problems

W

webman6393

I am having trouble with my excel spreadsheet. I enter a 7 digit number
under each day of the month in one row. In another row I formulate those
numbers to subtract then divide by 1000. For example I am attempting to
formulate cell E12 to do the following formula =(F10-E10)/1000. I then puxh
enter and the formula works. This is now where the problem exixts. As I
have always done in the past, I place my curser on the corner of cell E12
until I get a solid black cross and drag it from the E12 to AI12. The proper
formulas have been dragged across the row, but it has dragged the the same
number across the entire row, which is not accurate according to the numbers
I have placed in across row 12, which indicates the days of the
month.......Please help....very frustrated
 
N

Niek Otten

Tools>Options>Calculation tab, check Automatic calculation

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am having trouble with my excel spreadsheet. I enter a 7 digit number
| under each day of the month in one row. In another row I formulate those
| numbers to subtract then divide by 1000. For example I am attempting to
| formulate cell E12 to do the following formula =(F10-E10)/1000. I then puxh
| enter and the formula works. This is now where the problem exixts. As I
| have always done in the past, I place my curser on the corner of cell E12
| until I get a solid black cross and drag it from the E12 to AI12. The proper
| formulas have been dragged across the row, but it has dragged the the same
| number across the entire row, which is not accurate according to the numbers
| I have placed in across row 12, which indicates the days of the
| month.......Please help....very frustrated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replacing A Column Of Numbers 2
formula 3
IF AND VLOOKUP formula needed 1
Excel Excel help please 1
Formula ... Minus Holidays? 1
Force input in multiple cells in Excel form 8
Help with formula 2
Vlookup Formula 4

Top