Special Formulas For Worksheets

corndale

New Member
Joined
May 12, 2002
Messages
11
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
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,454
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

Legend
Joined
Sep 3, 2002
Messages
10,473
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,318
Messages
5,600,925
Members
414,416
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top