While were in a mutual sharing mood, it is also good practice to make legible constants out of magic numbers - such as the 7.1 in the example. If the value changes, you only have to do it in one place and not worry if you have missed it somewhere.
=IF(AND(L8<maxval;L8>0);L8;maxval) Dave On 11/19/05, Terry North <[EMAIL PROTECTED]> wrote: > > In the following paragraph of my previous post "in which case" should read > "otherwise" > > > 3. I want a formula that returns the value in L8 if it is greater than > zero and lower than 7.1 (in which case it returns the value 7.1). The > following did not work: =IF(AND(L8<7.1;L8>0)="TRUE";L8;7.1). Fortunately, > the following did: > =IF(AND(L8<7.1;L8>0)=1;L8;7.1). > > > > Regards, Terry. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com
