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 to get it put together correctly.
2 Replies
Jeremiah2315 , as variant that could be nested IF like
=IF(A1>P1,1,IF(A1<P1,-1,0))
as well as other formulas.
- What's your IF formula?
