I have a proposed budget with three different scenarios, called “A,” “B” and of course, “C.” Each has different budget amounts in certain categories, dependent on the scenario. I insert the applicable budget amount using the Data Validation Tool along with an IF statement, so that =IF(A1="A","A Shows",IF(A1="B","Now B Shows",IF(A1="C","And Finally C Shows"))) (an example) works to give me the desired value in the correct box.
However, I want to make a calculation that rounds up my totals in a way that is applicable to each scenario, and which requires that I round up to three different larger increments, 100,000, 200,0000 and 300,000. I do not want to merely add those amounts, I want the totals rounded up to the next increment of those.
Example, if A is $932, then it might round up to $100,000, while if B were $273,000, it would round up to $400,000 and C if it was $675,000 would round up to $678,000.
I can’t find anything other than someone who wanted to round down to the next 100, but I couldn’t get that to work.
Anyone have any ideas?
), and/or