Forum Discussion
Format an equation
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 t...
Jeremiah2315 , as variant that could be nested IF like
=IF(A1>P1,1,IF(A1<P1,-1,0))
as well as other formulas.