D Douglas J Steele Oct 11, 2005 #2 IIf(C>D, C*E, D*E) -- Doug Steele, Microsoft Access MVP (no e-mails, please!) "(e-mail address removed)"
IIf(C>D, C*E, D*E) -- Doug Steele, Microsoft Access MVP (no e-mails, please!) "(e-mail address removed)"
J John Vinson Oct 11, 2005 #3 need formula for if C OR D is greater multiply it by E THANK YOU Click to expand... [E] * IIf([C] > [D], [C], [D]) John W. Vinson[MVP]
need formula for if C OR D is greater multiply it by E THANK YOU Click to expand... [E] * IIf([C] > [D], [C], [D]) John W. Vinson[MVP]