Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
=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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|