Here's my problem. I need for a cell to produce 3 different answers based on the number in a referenced cell.

If the the referenced cell is < 2,000 then I want the other cell to add 15% to the number.

If the referenced cell is 2,000 to 9,999 then I want the other cell to add 10%

and If the the referenced cell is 10,000 or greater, I want the other cell to add 5%

I also would like the result to be be rounded up to the nearest hundred.

I've managed to make a working formula for the 1st 2 statement but I can't figure out had to add the 3rd.

Here is the formula that I have:

=ROUNDUP(IF('Text Prep.Presswork.Bind'!B12<2000, 'Text Prep.Presswork.Bind'!B12*1.15, 'Text Prep.Presswork.Bind'!B12*1.1),-2)