Format an equation

[Jeremiah2315]

Hi, I have an equation I’m trying to generate in one cell based off rather or not another cell is greater than/less than/equal too a certain percentage. I’ve tried using “If function” but can’t seem to get it put together correctly.

[#2]

What's your IF formula?

[#3]

@Jeremiah2315 , as variant that could be nested IF like

=IF(A1>P1,1,IF(A1<P1,-1,0))

as well as other formulas.