Forum Discussion
Solved
Excel Formula for price by tier with an interval
Hi all I'm hoping for an excel formula that can calculate the following tiers/sums based on the value in just one cell (A1) to show a result in only one other cell. Where A1 is <25,000 price to pay...
Sorry, my bad. See the attached version.
OK cool.
Just gave it a test. I'm afraid when A1 is 500,000 or above, I get only get "-" value unfortunately.
Will keep trying to tweak it in the meantime.
Thanks again.
Nick
Sorry, my bad. See the attached version.