Special Formulas For Worksheets

[corndale]

I have a worksheet/workbook which I use for our church's bus trips and need assistance in further customizing formulas, as follows:

Names & Fares Paid sheet-Column L - this column is the fare for the trip. Currently, I enter the balance manually in Column L. Cell C28 of the Expenses sheet, which is the total fares to be collected, links to Cell L65 of Names & Fares Paid.
1. Column A of Names & Fares Paid is a special column for children whose fare will not be calculated in the total. I would like to put an X in the Cell and have the Balance in the corresponding cell in Column L display $0.
2. I would like to enter the Balance one time in cell L5 of Names & Fares Paid, and have a formula that will cause this amount to be copied in Column L of a the rows below only when there is a name in Columns C & D of that row, except when there is an X in Column A of that row. If there is no name in Columns C & D, Column L of that row will either be blank or display $0.

I copied the worksheet below. Is there a way that I can attach the worksheet in this forum so you can see exactly how it displays in Excel?

Destination
Date
Updated
X # NAME AMOUNT DATE AMOUNT DATE AMOUNT DATE PAID BALANCE
1 $0.00 $0.00
2 $0.00 $0.00
3 $0.00 $0.00
4 $0.00 $0.00
5 $0.00 $0.00
6 $0.00 $0.00
7 $0.00 $0.00
8 $0.00 $0.00
9 $0.00 $0.00
10 $0.00 $0.00
11 $0.00 $0.00
12 $0.00 $0.00
13 $0.00 $0.00
14 $0.00 $0.00
15 $0.00 $0.00
16 $0.00 $0.00
17 $0.00 $0.00
18 $0.00 $0.00
19 $0.00 $0.00
20 $0.00 $0.00
21 $0.00 $0.00
22 $0.00 $0.00
23 $0.00 $0.00
24 $0.00 $0.00
25 $0.00 $0.00
26 $0.00 $0.00
27 $0.00 $0.00
28 $0.00 $0.00
29 $0.00 $0.00
30 $0.00 $0.00
31 $0.00 $0.00
32 $0.00 $0.00
33 $0.00 $0.00
34 $0.00 $0.00
35 $0.00 $0.00
36 $0.00 $0.00
37 $0.00 $0.00
38 $0.00 $0.00
39 $0.00 $0.00
40 $0.00 $0.00
41 $0.00 $0.00
42 $0.00 $0.00
43 $0.00 $0.00
44 $0.00 $0.00
45 $0.00 $0.00
46 $0.00 $0.00
47 $0.00 $0.00
48 $0.00 $0.00
49 $0.00 $0.00
50 $0.00 $0.00
51 $0.00 $0.00
52 $0.00 $0.00
53 $0.00 $0.00
54 $0.00 $0.00
55 $0.00 $0.00
56 $0.00 $0.00
57 $0.00 $0.00
58 $0.00 $0.00
59 $0.00 $0.00
60 $0.00 $0.00
61 $0.00 $0.00
TOTAL $0.00 $0.00




Date
Total Bus Fares Collected & Paid Out Total Offerings Collected & Paid Out

Comment Date Amount Comment Date Amount
Total Collected 1/0/00 $0.00 Total Collected 1/0/1900 $0.00
Turned Over To Church Turned Over To Church
Turned Over To Church Turned Over To Church
Turned Over To Church Turned Over To Church
Turned Over To Church Turned Over To Church
Turned Over To Church Turned Over To Church
Turned Over To Church Turned Over To Church
Turned Over To Church Turned Over To Church
Turned Over To Church Turned Over To Church
Refunded Turned Over To Church







Total Bus Fares Turned Over To Church $0.00 Total Offerings Turned Over To Church $0.00
Balance To Be Turned Over To Church $0.00 Balance To Be Turned Over To Church $0.00
Amount Left To Be Collected $0.00
Grand Total Turned Over To Church $0.00

 

[HalfAce]

Is there a way that I can attach the worksheet in this forum so you can see exactly how it displays in Excel?

Check out COLO's HTML Maker utility at the bottom of the page. This will allow you to do display your sheet on the board.

Hope it helps,
Dan

 

[just_jon]

Actually, Colo's utility has not yet been restored to functional yet, but it's a good thing to have for when it does return.

 

[KenWright]

Which hopefully will be very very soon