if is number or 0

[loucifer777]

hi to everyone,i need a formula at B:B which follows A:A and if at A=any number write at B=2 or if A=0 to writeat B=1.thanks

[AliGW]

In B1 copied down:

=IF(A1>0,2,1)

You may need this version for your locale:

=IF(A1>0;2;1)

[loucifer777]

thanks ,but at A10 it shows 1,i want when A is empty B to be empty

[AliGW]

You didn't say that, though, did you?

Try this:

=IF(A1="","",IF(A1>0,2,1))

For your locale:

=IF(A1="";"";IF(A1>0;2;1))

This is a basic nested IF formula.

[Sam Capricci]

then just add this to Ali's formula... =IF(A1="","",IF(A1>0,2,1))
or her other formula =IF(A1="";"";IF(A1>0;2;1))

wasn't sure if Ali was working another post so thought I'd help out, not needed. LOL.

[loucifer777]

thanks ,excelent

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[CARACALLA]

B2=IF(ISBLANK(A1),"",IF(OR(SIGN(A1)=1,SIGN(A1)=-1),2,1))

Copy down