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 Splendid Dec 19, 2010 9,588 0 31,960 Sep 7, 2012 #2 In Microsoft Excel it would be: Code: =IF(OR(A1<0; A1>100); "DON’T PRINT"; "PRINT") Upvote 0 Downvote