How to format a formula with a percent that will not result in a negative number Tags: Office Formula Format Apps Last response: September 7, 2012 2:38 PM in Applications Share mogranger 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 Sunius September 7, 2012 2:38:13 PM In Microsoft Excel it would be: =IF(OR(A1<0; A1>100); "DON’T PRINT"; "PRINT") m 0 l Can't find your answer ? Ask ! Publish Related resources How to find out the number of times a PC has been formatted? Forum How to write international format in entering mobile phone number Forum More resources Read discussions in other Applications categories Graphics Internet Applications Multimedia Office Security CAD Distributed Computing Drivers Enterprise Software Firmware Programming Photoshop Skype Wordpress !