Thank you so much! Is there a way to add if another check fox is checked it subtracts the entire expense calculating to 0. Ex: Checkbox A (like you just explained) but then for the total cost if Checkbox B is checked then it subtracts the full amount and if it is not checked it keeps the full amount? This is used our expense reporting and for our partnership co-op dollars if it is a co-branded, our partner covers half the cost, if it is fully branded by them they cover the whole expense and if its not co-op at all we cover the entire expense
the total cost needs to be 0 if full co-op is checked and the total cost needs to be multiplied by 50% if it is checked. If neither are checked it needs to stay the full amount. I tried to use the second formula you send and it is giving me an error.