Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

Dear Friends
Please cancel my previous request, I have resubmitted this request with a
simpler spreadsheet to explain my quest. This spreadsheet will, if
successful will be used to allocate funds from around 200 people across
approx. 20 charities.

I am trying to construct a simple spreadsheet for the allocation of Gift Aid
Refunds to different charities.
My apologies for the layout of the spreadsheet, it changes from the original
when I preview it.

To explain:-
Column A = Envelope number held by a specific person, this could also be a
Column B = The total amount that person gave to the charity
Column C = cell which confirms that the allocation to specific funds equals
the total amount donated, this adds together totals in each fund column.
Column D = This identifies if the person giving the donation has signed a
gift aid form. If the cell is "Y" then the Gift Aid Refund allocation can be
added to the individual funds. If the cell indicates "N" then the Gift aid
form has not been signed therefore there will be no gift aid allocation.
Cell D2 shows the Gift Aid Refund rate claimable.
Columns E, G, etc. shows how the donor has asked for his donations to be
allocated within the charity
Columns F, H, etc.. shows the amount in Gift Aid refunds should be allocated
to each fund.
In the example below you will see that envelope 1 has signed a Gift Aid form
and therefore his donations to funds 1 & 2 are increased by £12.50 each.
Env. 2 has not signed the Gift Aid form, therefore no Gift aid can be

Could someone please give me the formula to use to identify the amount to
allocate, in cell F4 I have inserted the amount to allocated from Gift Aid
without the information in D4.
Perhaps someone might have a simpler way of assembling this spreadsheet, if
so I would be very grateful.

                Gift Aid Refund         25.00%                                                      
Fund 1                                   Fund 2
Env No.          Donation          Total Allocated          Gift Aid ?         
Fund 1          Gift Aid          Fund 2          Gift Aid
1                            £100.00                  £100.00                           
Y                    £50.00         £12.50           £50.00         £12.50
2                       £125.00             £125.00                          
N                    £100.00                                   £25.00   
3                          £0.00                                        
4                          £0.00                                        
5                          £0.00                                        

View this message in context:
Sent from the Users mailing list archive at

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.