• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula does not work

keanur

Member
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
 

Attachments

  • tes.xlsx
    8.8 KB · Views: 3
You have Calculation set to manual
Press F9 to recalculate now

To set it to Automatic goto
Formulas' Calculation Options
 
Back
Top