Completely Stuck

[bumfart66]

The formula in AH 17 is =AH14-AH16 , why does it show 0?

The formula =AG14-AG16 works ok, but if i drag this formula across it will put £39750.40 in cell AH17

 

[Macropod]

Is auto calculation on? Do you have circular references somewhere?

 

[bumfart66]

It seems to go wrong at column AD, this is when row two (AD2) pulls some numbers from a different tab , auto calculation is on and i corrected one circular formula

If i change the value in AD2 to zero and remove the link to the different tab it works ok

 

[Macropod]

That suggests you've got more circular references to deal with.