Need help with an Excel formula - EXAMPLE: Need to enter a formula into Cell C1 to multiply a number entered in Cell A1 (20,000) by the number in Cell B1 (.03%), if the resulting product is less than 10, I need the formula to apply 10 as the minimum acceptable number (i.e., 20,000 x .03% = $6.00, but need the cell to reflect a round up to $10 even)

=if(a1*b1>10,a1*b1,10)

Razor2.3 - Thanks so much for the quick response (yahoo - it works!) One other question: Is there any way of getting the cell to return "0" if there is not yet any calculation down the entire column (I've provided 25 lines for individual transactions, but the problem is that on the lines not yet used, it's showing the $10 minimum where (at this point) it should be zero? (Thanks so much - you're a life saver!)

=if(or(a1*b1>10,a1*b1=0),a1*b1,10) Edit: That'll require both colums to be non-zero (and not empty). If you just want to test if A1 is blank, try =IF(OR(A1*B1>10,ISBLANK(A1)),A1*B1,10)

Hey Razor2.3 - Perfect - just what I was looking for. thanks so much for your help (I spent all afternoon trying different formulas and nothing worked -- didn't know if I should have been going with round, roundup, etc. This is exactly what I needed for my sheet -- many many many thanks. Have a great evening