|I'm trying to create a conditional formula in Excel 2007 to calculate a dollar amount, based on a set of tiered numbers.|
IF D2= any number 1 through 10, multiply it by 50
IF D2= any number between 11 through 14, multiply by 75
IF D2= any number greater than 15, multiply by 100
Here's what I have, but this isn't working - it keeps saying TRUE when I enter in numbers into D2.
Suppose 20 multiply above number & answer 1400.