Hey everyone, I know what I want to do but can't get it to line up.
So, I adjust credit lines and my methodology is to take the highest month of sales in a rolling 12 months and build in a little headroom. So if the high sales for a month is $168,589.33 I take that number and divide by .75.
168,589.33/.75=224,785.77
Now $224,785.77 is not a good credit limit. I would go to the nearest thousand when writing this up for approval to $225K.
What would the formula look like to calculate the high sales/.75 and then round up? Can that all be done in a single cell? I really don't want to have a cell for the calculation and then a 2nd cell for the round up formula.
So, I adjust credit lines and my methodology is to take the highest month of sales in a rolling 12 months and build in a little headroom. So if the high sales for a month is $168,589.33 I take that number and divide by .75.
168,589.33/.75=224,785.77
Now $224,785.77 is not a good credit limit. I would go to the nearest thousand when writing this up for approval to $225K.
What would the formula look like to calculate the high sales/.75 and then round up? Can that all be done in a single cell? I really don't want to have a cell for the calculation and then a 2nd cell for the round up formula.