I assumed from your question that you wanted A1+B1 if that is between 0% and
100%. If you want something else other than A1+B1, put that instead of
A1+B1 in the formula.
--
David Biddulph

"Lorne" wrote in message
...
wow, that is good, but missing what the actual % would be if between 100%
and
0%. Sorry if i was not clear on that part. But I am so happy with this
so
far. Thank you

"David Biddulph" wrote:

=median(0%,A1+B1,100%)
--
David Biddulph

"Lorne" wrote in message
...
here is my problem, I have three cells a1,b1,c1. a1: fixed, b1:
variable,
c1:
total of both as a %. I need to find the total precent the B1 maybe
either
(+) or a (-) number. if over 100% to indicate it as "100%", if between
100%
and 0% to indicate it as is, and if under 0% to indicate it as a "0%".
I
am
not even sure if its possibe.