Formula needed

[Hassan]

HI All,

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

help required,

Hasan

 

[Gary''s Student]

=IF((A1>0)*(A1<101),A1,"")

 

[Hassan]

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

 

[Pete_UK]

Try this:

=IF(D2<=0,0,(C2/D2*100))

Hope this helps.

Pete

 

[Gary''s Student]

Consider using two cells rather than one.

Keep your formula in H2 and in another cell:

=MIN(MAX(H2,0),100)

 

[David Biddulph]

=MAX(0,if(d2=0,0,c2/d2*100))
--
David Biddulph

....

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
"-"

....

 

[David Biddulph]

But if D2 is +ve and C2 is -ve, this would return a -ve result, and if C2
and D2 are both -ve, this would return zero rather than the +ve result.
--
David Biddulph

Try this:

=IF(D2<=0,0,(C2/D2*100))

Hope this helps.

Pete