formula to multiply 2 cells #'s if cell "x" has a number between ? & ?
J JulieD Oct 13, 2004 #2 Hi Aaron it would probably help if you had used actual cell references and values in your question but here goes =IF(AND(A1<10,A1>5),A1*B1,"") this will multiply A1 by B1 if A1 is greater than 5 and less than 10 Cheers JulieD
Hi Aaron it would probably help if you had used actual cell references and values in your question but here goes =IF(AND(A1<10,A1>5),A1*B1,"") this will multiply A1 by B1 if A1 is greater than 5 and less than 10 Cheers JulieD
