Looking for an EXCEL function that allocates a specific value (i.e. 1) under certain conditions (i.e. if its?

>0 or <0)

Can someone help me with this?
I can't seem to remember which function to use, and have been looking for an hour.

Thanks!

Your question is somewhat vague. Here is one formula that may help:

=if(A1<0,1,"")

It means if the value in cell A1 is less than zero then the cell containing this formula will return 1, else return nothing.

. .

Way to be vague! Nice.
If a numerical value is NOT < 0 OR > 0 then it equals 0. This is simple logic.
-=-=-
assuming the value in question is then =if( = 0, , 1) will assign the value of 1 to the cell if does not evaluate to zero and will become if it is zero. Additional conditions, such as making sure is a number would require nested if( ) statements...
=if(isnumber(),if( = 0, , 1),"error not a number")
where I've used an error message for a second .
-=-=-=
You aren't thinking that the itself will be changed, are you?