/ Sign-up
Your question

How to format a formula with a percent that will not result in a negative number

  • Office
  • Formula
  • Format
  • Apps
Last response: in Apps General Discussion
September 7, 2012 1:32:12 PM

I have a spread sheet in which the formula uses a Precentage to calculate values , however I want to exclude any negative numbers and also numbers over 100. What element do I add to the formula to obtain this desired result? Thanks

More about : format formula percent result negative number

September 7, 2012 2:38:13 PM

In Microsoft Excel it would be:

  1. =IF(OR(A1<0; A1>100); "DON’T PRINT"; "PRINT")