Excel not correctly calculating formula

  • Thread starter Thread starter Darren Ingram
  • Start date Start date
D

Darren Ingram

Hi all,

I've created the following formula =IF($D7="pc",($F7-$E7+1),"") in column
K which is a formula that leaves the number of days between two periods F7 &
E7 if D7 is "pc".

Anyway I then drag this formula down column K and instead of leaving the
correct number it just leaves the value of the first box K7. Even though the
formula changes as you go down the rows correctly it just leaves the first
value. Where as each row is a different date.

When I type the formula manually into row 8 it then calculates that row
correctly but when dragged down it just leave the value for row 8 instead of
7.

Please help me as I've looked at all the formatting for said columns and
double checked the coding but all seems to be correct.....however with
incorrect answers.

Help genuinely appreciated.
 
It sounds like the sheet has been set for manual calculation - press
F9 to see if the formula evaluates correctly. To change permanently to
automatic calculation mode, click on Tools | Options | Calculation tab
and then check Automatic.

Hope this helps.

Pete
 
Pete / Bernie,

Thanks....all working. You'd probably understand how much hair I pulled out
on that one wonder why it wasn't working. I did originally check all my
"options" but I think the fact that I was frustrated with what was going on,
my eyes must have glazed over the Automatic tick box...

Thanks for your help.

Darren.
 
Pete / Bernie,

Thanks....all working. You'd probably understand how much hair I pulled out
on that one wonder why it wasn't working. I did originally check all my
"options" but I think the fact that I was frustrated with what was going on,
my eyes must have glazed over the Automatic tick box...

Thanks for your help.

Darren.
 
Back
Top