=MAX(A/B,1)
If you really mean quotient, try:
=MAX(INT(A/B),1)
HTH
Jason
Atlanta, GA
-----Original Message-----
Is there a way to set the mimum value at 1 for all
quotients?
Example:
A/B=C How do I get C to be a minimum of 1 if the
quotient of A/B= less than 1?
Any help is greatly appreciated.
Robert
.
|