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

mogranger

Honorable
Sep 7, 2012
1
0
10,510
0
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
 
Thread starter Similar threads Forum Replies Date
B Apps General Discussion 2
H Apps General Discussion 2
A Apps General Discussion 2
P Apps General Discussion 1
C Apps General Discussion 1
B Apps General Discussion 8
V Apps General Discussion 1
L Apps General Discussion 3
S Apps General Discussion 2
D Apps General Discussion 3
G Apps General Discussion 2
C Apps General Discussion 4
T Apps General Discussion 31
T Apps General Discussion 1
S Apps General Discussion 1
S Apps General Discussion 1
B Apps General Discussion 1
A Apps General Discussion 7
Z Apps General Discussion 1
P Apps General Discussion 5

ASK THE COMMUNITY