formula not working

I have a formula that simply says

=IF(K2=0,J2,K2)

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?
JagwarmanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
You may try to use quotes...
=IF(K2='0',J2,K2)
0
 
Saqib Husain, SyedEngineerCommented:
What do you have in K2 and J2?
0
 
JagwarmanAuthor Commented:
The reason was that somehow during the running of the existing Macro it turned off Auto Calc.
0
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.