Sign in with
Sign up | Sign in
Your question

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

Last response: in Applications
Share
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
September 7, 2012 2:38:13 PM

In Microsoft Excel it would be:

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