Solved Help putting greater than or less than plus a percentage

January 25, 2012 at 20:29:57
Specs: Windows 7
I'm trying in create a mark up that looks like this

0-9.99 10%
10.00-25.00 25%
25.01 - 100.00 35%


See More: Help putting greater than or less than plus a percentage

Report •

#1
January 25, 2012 at 20:35:57
✔ Best Answer
=IF(A1<10,A1*.01,IF(A1<25.01,A1*.25,A1*.35))

Assuming that A1 will never be greater than 100 since you don't give a condition for that.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 25, 2012 at 20:44:52
Here is the exact way I'm trying to do this...

$0.00 - $9.99 = 4x, $10.00 - $13.99 = 3.5x, $14.00 - $17.99 = 3x, $18.00 - $21.99 = 2.5x, $22.00 - $25.99 = 2x, $26.00 - $29.99 = 1.5x, $29.99 - $32.99 = 1x

Would you be able to help?

Thanks!


Report •

#3
January 25, 2012 at 20:53:11
And how would I be able to make it repeat in the entire column?

Report •

Related Solutions

#4
January 26, 2012 at 07:38:27
What does 4x, 3.5x, etc. mean?

Keep in mind that we can't see your spreadsheet from where we're sitting so you need to be clear and complete when you post your requirements.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question