Solved My Excel calculation problem

August 10, 2012 at 23:38:59
Specs: Windows XP
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.

See More: My Excel calculation problem

Report •

August 11, 2012 at 04:54:07
✔ Best Answer
Try this:

Report •
Related Solutions

Ask Question