Excel IF Statement

Copper Contributor

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
=IF(P13>0,M13,0)
This should get you what you need.
=IF(P13<=0,0,M13)
Thanks - did the trick. Learning here!