I need help with a numeric function. I'm trying to verify if the answer is positive and if so, want the value to be returned. If negative, I want it null.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I'm trying to do an if statement to verify if the results are positive.  if positive, I want the calculation to run and populate w/ the answer.  If the result would be negative, I want the function to stop and return a null answer.  How do I do this?  Here is what I'm working with: 


If([Minimum Stock] - [Amount]>0, [Minimum Stock] - [Amount] , "")

Photo of Jason

Jason

  • 30 Points

Posted 4 years ago

  • 0
  • 1
If([Minimum Stock] - [Amount]>0, [Minimum Stock] - [Amount])
Photo of Jason

Jason

  • 30 Points
Well, that was complicated.  HAHA  I totally didn't think about that.
In an IF formula if you are silent about the "else", then it becomes null.  :)