Gift aid is a scheme that allows charities to claim an extra 25% from the Taxman if the donor is a UK Tax Payer. This tutorial shows how by using an IF statement in Excel you can calculate the Gift Aid for donors who are UK Tax Payers, but leave the gift aid column blank for those who are not.
At work we have a newsletter that we send out three times a year. We send it out in both print and E:Mail. We’re trying to get as many people as possible to switch to the E:Mail edition as this cuts costs, and inbetween issues several people have switched to E:Mail. I wanted to compare the e:mail addresses on our customer database with those in our mailing list software, and add those that did not exist. To do this I used Excel conditional formatting feature to highlight the addresses that only appeared on the customer database and not in the mailing list