HI
i want to express in a column based on criteria in another column
column N has a currency amount
i want to populate column O based on that number:
if column N has a positive amount populate in column o "1"
if column N has a o amount populate in column o "o"
if column N has a negative amount populate in column o "credit"
I have
=IF(OFFSET (N2;0;-1)>O ; "1" ; IF(OFFSET (N2;0;-1)=0; "0" ; "CREDIT" ) )
but am not getting the output i expect - actually am getting an error
i can do the following successfully:
=IF(N2 >0, 1, 0)
which will give me the "0" or "1" for >0 or <=0
but am having trouble adding the condition for a negative number
thanks!
scuba2x2
Bookmarks