Excel not correctly calculating formula
 

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.

Excel not correctly calculating formula
 

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

On Jul 29, 12:16*pm, Darren Ingram
wrote:
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.

Excel not correctly calculating formula
 

Darren,

Try: Tools / Options... Calculation Automatic

HTH,
Bernie
MS Excel MVP


"Darren Ingram" wrote in message
...
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.

Excel not correctly calculating formula
 

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" wrote:

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

On Jul 29, 12:16 pm, Darren Ingram
wrote:
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.

Excel not correctly calculating formula
 

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.

"Bernie Deitrick" wrote:

Darren,

Try: Tools / Options... Calculation Automatic

HTH,
Bernie
MS Excel MVP


"Darren Ingram" wrote in message
...
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.

Excel not correctly calculating formula
 

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

Pete

On Jul 29, 1:40*pm, Darren Ingram
wrote:
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" wrote:
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

On Jul 29, 12:16 pm, Darren Ingram
wrote:
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.- Hide quoted text -

- Show quoted text -