| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - not equal 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF - not equal 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" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF - not equal to
Doesn't work either... but thanks for your suggestion.
Anything else I could try? /J.Jansson "Max" wrote: 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" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF - not equal 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" wrote: 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" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF - not equal to
Glad you got it sorted out ..
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "j.jansson" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
| #ref to equal zero | Excel Worksheet Functions | |||
| Value of Less Than Zero to Equal Zero | Excel Discussion (Misc queries) | |||
| Between or Equal to | Excel Discussion (Misc queries) | |||
| Getting 0 to equal 1 | Excel Worksheet Functions | |||
![j.jansson[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
