IF - not equal to


G

Guest

Hello

I cant get an easy formula to work... I have A and B column and want C to
look as below

A B C
0 0 X
0 J J
J 0 J

I've tried =IF(A1<>0;A1;IF(B1<>0;B1;X)) but I just get 0:s in the C column.
What an I doing wrong? Can anyone help me?


/J.Jansson
 
Ad

Advertisements

G

Guest

Try it with "" wrapped around the X, ie:
=IF(A1<>0;A1;IF(B1<>0;B1;"X"))
 
G

Guest

Doesn't work either... but thanks for your suggestion.

Anything else I could try?

/J.Jansson
 
G

Guest

Ok, i found the problem. The "0" were not a number, excel thought it was text
and when i added the " " around 0 I got the answer i was looking for.

/J
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NOT equal to 5
if this equals that 2
IF equals this OR this 3
SUMPRODUCT with not equals (<>) 3
spreading equally 8
Equals function 4
Equal Cells 2
IF function... not equal to 0

Top