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%

=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.

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!

And how would I be able to make it repeat in the entire column?

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.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History