Hi Gary,

thanks for response, kindly advice me how to merge two formulas, means I am
applying formula in h2, formula is "=if(d2=0,0,(c2/d2*100))
I want if the value is less then 0 then it returns 0 not values in minus "-"

Thanks

Hassan

"Gary''s Student" wrote:

=IF((A10)*(A1<101),A1,"")
--
Gary''s Student - gsnu200772


"Hassan" wrote:

HI All,

I am looking for a formula that keep the result of other formula between 1
to 100.

help required,

Hasan