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") Can't find your answer ? Ask ! Publish Related resources : ForumExpert: 40 Percent of World of Warcraft Players Addicted ForumDSLRs or Slide Film or Colour Negative Film? ;o) ForumExcel - using a range (in one cell) in a formula ForumDissapointed with TH's attitude about game piracy ForumTim Brooks (Shrapnel) on why retail is dead ForumDANGIT! I just bought Vista!!! ForumDigital vs 35mm lenses ForumAMD Overclocking Club ForumHow should I permanently store digital photographs? ForumHow many mp's to match resolution of 4x5 neg film cam? ForumWhy do I experience lag under 50 FPS. ForumAsus Maximus Formula Instability after 2nd RMA Help! ForumRankig of Vtes Debate Forumreducing image size for web pages? ForumWhat is the difference between Extended and normal version of a software? ForumUse audacity to record audio with turtle beach x31? Forum[Solved] C# How to do a math operation with one button and one text box? ForumWindows XP 32 bit connected to windows 7 64 bit that is hosting a printer. ForumMusic playing software that deletes a file(mp3)also form the hard disck not only ForumHow do i change website from german to english 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 !