I'm creating a tiered pricing structure that changes based on the number in a certain cell.
Basically - here it is 0-25K = .05, 25K-100K = .03, >100K = .01
The number has to fall within those ranges to get the correct amount.
How do I do this in a quick efficient way without having to do the IF statements and combinations? I can do that but it seems like the long way.
Thoughts?
Matt
Hello
I think writing you own formula would be ideal, particularly if the values could change in the future. Then you have 1 place to make the change. Something like :
Regards
Please Login or Register to view this content.
Most helpful to mark solved items as such (see help for directions). Star ratings are always welcome.
As an addition, you could improve it by specifying the 3rd range and rather use the else for invalid data like :
Please Login or Register to view this content.
0-25K and 25K-100K overlap
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks