Forum Discussion
BobWhiteJax
Aug 05, 2022Copper Contributor
Excel IF Statement
Not a super user and trying to set up simple IF statement. Tried online help but not getting where I need to be.
Solving for R13
If P13 is negative or zero, R13 should be zero
If P13 is positive, R13 should be equal to M13
Thanks - Bob
3 Replies
- BobOrrellIron ContributorThis should get you what you need.
=IF(P13<=0,0,M13) - JagodragonIron Contributor=IF(P13>0,M13,0)
- BobWhiteJaxCopper ContributorThanks - did the trick. Learning here!