M mogranger Honorable Sep 7, 2012 1 0 10,510 Sep 7, 2012 #1 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
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
Sunius Distinguished Dec 19, 2010 390 0 19,060 Sep 7, 2012 #2 In Microsoft Excel it would be: Code: =IF(OR(A1<0; A1>100); "DON’T PRINT"; "PRINT") Upvote 0 Downvote