I want to update the pricing on a labor chart using a formula.
I want to input a percentage (ex. 15%) in a cell and have the respective cells (selected cell: $59.99) to increase 15% and round up to .00. I created a formula as seen in the screenshot for the $59.99 resulting in $71.00
If I want to, in the future, increase the labor costs by 10% or different percentage over the $71.00, how do I do this with the original 59.99 in the formula?
Hello @jdurst,
You must correct your formula. With the formula in the screenshot, if the base number is 10, and the increase (cell I1) is 50 %, you will get 20, that is an increment of 100 % (not 50 % as intended).
For to increase a 15 % of 59.99 you must multiply this value for 1+15/100 (that is 1.15) and you will get 68.9885, that rounded up is 69.00 (not 71.00).
You can put the 59.99 in an auxiliary column (say, D), and your formula will be =ROUNDUP(D5*(1+$I$1);0).
couldn’t you use the thread solution for cool code solution - for formula?
kind of like =if(and(condition1,condition2), etc… based on
like =if(and(p2=1,q2=1), formula, if(and(p2=1,q2=0), like so
thanks,
j.
