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