Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

IF - not equal to

0 views
Skip to first unread message

j.jansson

unread,
Sep 4, 2007, 5:42:01 AM9/4/07
to
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

Max

unread,
Sep 4, 2007, 5:52:05 AM9/4/07
to
Try it with "" wrapped around the X, ie:
=IF(A1<>0;A1;IF(B1<>0;B1;"X"))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

j.jansson

unread,
Sep 4, 2007, 6:52:03 AM9/4/07
to
Doesn't work either... but thanks for your suggestion.

Anything else I could try?

/J.Jansson

j.jansson

unread,
Sep 4, 2007, 6:54:00 AM9/4/07
to
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

Max

unread,
Sep 4, 2007, 12:11:10 PM9/4/07
to
Glad you got it sorted out ..

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"j.jansson" <jjan...@discussions.microsoft.com> wrote in message
news:2B2FCC8B-AED6-4978...@microsoft.com...
0 new messages