Equation Values

R

RED

I am trying to calculate the days between two dates. I have used both
equations =a1-b1 and =days360(a1,b2) and both have worked in the first cell.
I need to copy this equation to over 400 more lines. When I copy the
equation it gives the right equation in each cell, however the value is the
same value as the first cell.. Help please!
 
S

ShaneDevenshire

Hi,

Assuming that your data is different for all the other cells then the most
likely problem is the recalculation is set to Manual. Choose Tools, Options,
Calculation, and set Calculation to Automatic (2003 and earlier).
 
T

T. Valko

Make sure calculation is set to automatic:

Tools>Optons>Calculation tab>Automatic>OK
 
T

Tom Hutchins

Do your formulas have absolute references ($A$1 instead of A1)? That would
keep them pointing to the first cells no matter how many times you copied
them.

Or, is your calculation mode set to manual? Press F9 to manually recalc the
worksheet.

Hope this helps,

Hutch
 

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

How do I install Microsoft Equation 3.0 back to Office 365? 0
Goal Seeking via Excel 0
Can the IF function be used with values from multiple worksheets? 4
conditional format fails when copied 1
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Equation Efficiency? 1
Time date stamp 0
Tweaking a calculated field in a query 4

Top