Formula needed

H

Hassan

HI All,

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

help required,

Hasan
 
H

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
 
G

Gary''s Student

Consider using two cells rather than one.

Keep your formula in H2 and in another cell:

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

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
"-"
Click to expand...
....
 
D

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
 
Top