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.

=IF(D2<11,D2*50)+AND(D2>10,D2<15,D2*75)+AND(D2>14,D2*100)

Suppose 20 multiply above number & answer 1400.


See More: My Excel calculation problem

Report •


#1
August 11, 2012 at 04:54:07
✔ Best Answer
Try this:
=IF(AND(D2>=1;D2<11);D5*50;IF(D2<15;D2*75;D2*100))

Report •
Related Solutions


Ask Question