On Jan 27, 2:50*pm, Rae wrote:
How do I make this formula-if cell empty +1 if cell has
any value -1

First, you need to decide if you mean "really empty" (no formula and
no value) or "appears empty" (no formula, or a formula that returns
"").

Use ISBLANK(A1) to test for "really empty". Use A1="" to test for
"appears empty". I use the latter because it is more general,
covering both cases.

=if(A1="", 1, -1)

If you want the "+" sign in the first case, you can use the custom
format "+0;-0" (without the quotes).