Excel not correctly calculating formula

[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.

 

[Pete_UK]

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

 

[Bernie Deitrick]

Darren,

Try: Tools / Options... Calculation Automatic

HTH,
Bernie
MS Excel MVP

 

[Darren Ingram]

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.

 

[Darren Ingram]

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_UK]

You're welcome, Darren - thanks for feeding back.

Pete