|
This doesn't work for some negative values of A & B. Given A = -5 & B = -3 then C = -2 with Brendan's formula. But I doubt Greg's A & B are negative. Nice formula Brendan. Paul -- Paul Morgan Senior Programmer Analyst - Retail J. Jill Group 100 Birch Pond Drive, PO Box 2009 Tilton, NH 03276-2009 Phone: (603) 266-2117 Fax: (603) 266-2333 "Brendan Bispham" wrote > yes, essentially: > if a>b then int(a/b) will be > 1, and int(a/b)/int(a/b)=1 > if a<b then int(a/b) will be 0, and int(a/b)/int(a/b)=0 > multiply c with the result and you get what you want > > And these are the Query defined fields: > D ((a+1)/(b+1))-.5 12 5 > E d 7 0 > F e/d 7 0 > C (a-b) * f 7 0
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
