Solved

formula not working

Posted on 2015-01-16
3
35 Views
Last Modified: 2015-01-27
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?
0
Comment
Question by:Jagwarman
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 40554882
You may try to use quotes...
=IF(K2='0',J2,K2)
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 40554897
What do you have in K2 and J2?
0
 

Author Comment

by:Jagwarman
ID: 40554903
The reason was that somehow during the running of the existing Macro it turned off Auto Calc.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now