Formula does not work

[keanur]

Hi Excel Ninjas,

I have a small challenge, where as excel formula is not given any result. i have attached the sample. I put formula on cell A5 and copy it across A20 and still give result of 2. Would you advice on how i supposed to do on this.

Thanks,

Keanur

 

[Hui]

You have Calculation set to manual
Press F9 to recalculate now

To set it to Automatic goto
Formulas' Calculation Options

 

[keanur]

Hi Hui,

Thanks for the advice, it works now

cheers,

keanur