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 |
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 |