I need help with a formula. I have a column where I enter the amount we actually spent on an item. We then compare that to our budget column. However, some items are not included in the budget but we do want to see what we paid for them. To control this I created a column called (Exclude from Spend) with a check mark. However now is the hard part…how to have a final Spend column, that doesn’t include the check marked items. I know it’s a formula If Exclude from Spend is checked, do not include the amount or subtract the amount from the Final Spend column. But I have no idea where to start writing that.
Thank you that is sort of helpful. Ha. I wat to say if the Exclude from Spend is check “$0” and if the Exclude from Spend is not checked then = “Spend” column. I just don’t know how to write all of that!