I have a formula that divides the total amount between crew and scouts with scouts taking 15% of the total and crew splitting the rest. Im trying to incorporate a subtraction of 2.5% that the op leader is receiving but keep it flexible and able to be changed based on the corresponding chart. Im not sure where to put that into the existing formula. Attached is a copy of the sheet in question. For clarification the page in question is calculations and the columns are "H" and "K" , the corresponding chart would be M10:P16.
Bookmarks