formula not working

I have a formula that simply says


But it is returning 0 every time

I presume this is because the data is maybe Text Format but have tried changes to Number format.

Is there a solution?
Who is Participating?

Improve company productivity with a Business Account.Sign Up

Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
You may try to use quotes...
Saqib Husain, SyedEngineerCommented:
What do you have in K2 and J2?
JagwarmanAuthor Commented:
The reason was that somehow during the running of the existing Macro it turned off Auto Calc.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.