I need help with the following formulas.
A B C D E F G H No BUSINESS/DONOR ADDRESS CITY ZIP PHONE # DONATION VALUE MEMBER 18 STEAMATIC CLEANING 953 MEADOWLARK LANE STEPHENVILLE 965-2266 SPOT CLEANING KIT $25.00 17 M & J ANTIQUES 1050 E. WASHINGTON STEPHENVILLE 965-2208 COUNTRY CROSS-STICHED PILLOW $30.00 LEMONS 16 HEALTH FOODS CENTER BOX 99 GORMAN 734-2185 BLENDER $50.00 BAXTER 15 M T'S AQUARIUMS 2111 W. WASHINGTON STEPHENVILLE 965-2033 AQUARIUM - 25 GAL. $80.00 BAXTER 14 MY LITTLE BUCKAROO 199 N. BELKNAP STEPHENVILLE 965-1959 DORATINE PICTURE BOX $30.00 LEMONS 13 ONE STOP CONVENIENCE STORE 1660 LINGLEVILLE RD DUBLIN 445-2255 2 - $25 GIFT CERTIFICATE GOOD AT ANY 4 STORES $50.00 COLE 12 NATIONSBANK 115 N. GRAHAM ST. STEPHENVILLE 965-1800 VACATION GEAR (BEACH-UMBRELLA, CHAIR,2TOWELS,IGLOO) $100.00 LEMONS 9 11 SPECIALTIES INC. RT 2 BOX 231 DELEON 893-1489 2 - HANDMADE BABY BURP CLOTH $100.00 BAXTER 10 10 ALL AMERICAN AWARDS 140 W. SOUTH LOOP STEPHENVILLE 965-0887 2 - PLAQUES $29.90 LEMONS 11 9 MAIL BOXES ETC. 2900 W. WASHINGTON STEPHENVILLE 965-0724 GIFT CERTIFICATE $25.00 BAXTER 12 8 DELEON IRRIGATION RT 1 BOX 22-A DELEON 893-2123 3 - LAWN SPRINKLER $60.00 COLE 13 7 BIRDSONG PEANUTS BOX 698 GORMAN 734-2266 15 - 5LB BX OF SHELLED PEANUTS $150.00 LEMONS 14 6 DR. PEPPER BOTTLING DUBLIN 105 E. ELM DUBLIN 445-3466 DR. PEPPER PENDULUM CLOCK $ 175.00 COLE 15 5 LTC PRINTING 403 E. BLACKJACK STEPHENVILLE 445-3421 PRINTING CERTIFICATE $25.00 BAXTER 16 4 STEPHENVILLE NURSING HOME 2311 W. WASHINGTON STEPHENVILLE 445-2517 $75.00 SAVINGS ACCT W/ S'VILLE BANK & TRUST $75.00 LEMONS 17 3 CAIN POOL COMPANY HWY 377 SOUTH DUBLIN 445-2484 ASSORTED POOL MAINTENANCE SUPPLIES $95.95 BAXTER 18 2 GAINES OIL CO. P.O. BOX 188 DUBLIN 445-2255 4 SPIRAX HD (GEAR OIL) 85/140 35 LB BUCKET @ $35 $140.00 COLE 19 1 HOKA-HEY INC & FOSSIL RIM WILDLIFE CENTER HWY 377 S DUBLIN 445-2017 LETTER/NAPKIN HOLDER $125.00 BAXTER 20A B Input Area 2 Cost of home $ 150,000.00 3 Down Payment $ 10,000.00 4 APR 4.00% 5 No. Years for Loan 30 6 Payments Per Year 12 8 Output Area 9 Monthly Payment 10 11 12 13 14 15A B C DELEON 76444 DUBLIN 76446 GORMAN 76454 OUAWN STEPHENVILLE 764011. In cell B2 create a formula that lists today's date and change the font color to Blue and the Background color to Yellow. Please use a formula that will update it to the current date of the day that it is opened. In Cell J16, insert a title of Value Check. Adjust the width of the column to see the entire title. Starting in Cell J17, create an if statement that will check to make sure the value of the donation is a positive value. Anything that is greater than zero is Positive, anything that is 0 or less needs to be Not Positive. In H35 create a formula to give the Average Donation price of the data above. In H36 create a formula to give the Largest Donation price of the data above. In H37 create a formula to give the Smallest Donation price of the data above. In H38 create a formula to give the Total Donation price of the data above. Sort the data by City in Descending order. Inside of that sort, sort the data by Member in Descending Order. Hint: Multiple level sort used here. Highlight all of the data in the table and name the selected range as DONATIONSTABLE. 10. Starting cell E17 create a VLOOKUP that will reference the table on the City Sheet and return the Zip Code (column 2) based on the City Name. Copy and paste all the way down to the bottom of the data and make sure that you correctly reference. 11.Click on the Mortgage tab to pull up the Mortgage Sheet. In cell B9, create a payment function using the information provided in cells B2:B6. Make sure that every cell is referenced in the formula
