Forum Discussion
Jeremiah2315
May 13, 2019Copper Contributor
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
- SergeiBaklanDiamond Contributor
Jeremiah2315 , as variant that could be nested IF like
=IF(A1>P1,1,IF(A1<P1,-1,0))
as well as other formulas.
- TwifooSilver ContributorWhat's your IF formula?