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

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
1 answer Last reply
More about format formula percent result negative number
  1. In Microsoft Excel it would be:

    =IF(OR(A1<0; A1>100); "DON’T PRINT"; "PRINT")
Ask a new question

Read More

Office Formula Format Apps