Formula not getting evaluated

[krishna334]

Hi All,

In ROW 5 of column P of my worksheet i have a CSE formula:

=OnHandAvailAfterReq-(SUMPRODUCT((Comps=F5)*(IF(ISERROR(SOQty),0,SOQty))*(IF(ISERROR(SOQty),0,Qtyper))))

but when i drag the formula to the below cells, its not getting evaluated correctly...i need to go to each cell..press F2 and then press Enter to get the correct value.

Why the formula doesn't get evaluated as soon as i drag it?

Advance Thanks for any help.

 

[dave3009]

Is calculation set to manual?

 

[prince141987]

Just Set the Calculation option as Automatic in excel.

Regards
Prince

 

[krishna334]

how can i set that?

 

[jarjarbingie]

go to Formulas menu, Calculation Mode, set to Automatic..