Excel Project #2 - If Functions

Your requirements for this project are as follows:

• Create a formula for the Fixed Penalty column using the information in my comment
• Create a formula for the 90-Days Penalty column using the information in my comment
• Create a formula for the Graduated Penalty column using the information in my comment
• Create a formula for the Category Penalty column using the information in my comment

| J K Category Penalties Labor Utilities Other 6% 9% 12% 90-Days Penalty Graduated Penalty Category Penalty B E F G H 1 Fixed Fee & 90 Day Penalties Graduated Penalties - Range Penalty 2 Fixed Fee Penalty $ 45 Graduated penalty 3,000 250 4 90-day penalty percentage 12% Graduated penalty >= 10.000 600 5 6 7 TheZone Accounts Payable - Outstanding Balance Report Applies Total Past Fixed 30-Days 60-Days 90-Days Due Fixed 8 Vendor Name Category Penalty Past Due Past Due Past Due Balance Penalty 9 RTF Electric Utilities FALSE $ 18.100 S 0 S 0 $ 18,100 10 Ross County Water & Sewer Utilities FALSE 500 0 0 500 11 YNC Trucking Transportation TRUE 0 0 3.100 3.100 12 Italian Leather Group Ltd. Raw Materials TRUE 0 850 5,674 6,524 13 Union Plastics Raw Materials TRUE 7,250 436 0 7,686 14 Freight to Go Transportation FALSE 0 0 8.730 8,730 15 Temps R'Us Labor FALSE 2,700 0 0 2,700 16 Notworth Telephone Telephone TRUE 250 0 0 250 17 18 19 20 21 | J K Category Penalties Labor Utilities Other 6% 9% 12% 90-Days Penalty Graduated Penalty Category Penalty B E F G H 1 Fixed Fee & 90 Day Penalties Graduated Penalties - Range Penalty 2 Fixed Fee Penalty $ 45 Graduated penalty 3,000 250 4 90-day penalty percentage 12% Graduated penalty >= 10.000 600 5 6 7 TheZone Accounts Payable - Outstanding Balance Report Applies Total Past Fixed 30-Days 60-Days 90-Days Due Fixed 8 Vendor Name Category Penalty Past Due Past Due Past Due Balance Penalty 9 RTF Electric Utilities FALSE $ 18.100 S 0 S 0 $ 18,100 10 Ross County Water & Sewer Utilities FALSE 500 0 0 500 11 YNC Trucking Transportation TRUE 0 0 3.100 3.100 12 Italian Leather Group Ltd. Raw Materials TRUE 0 850 5,674 6,524 13 Union Plastics Raw Materials TRUE 7,250 436 0 7,686 14 Freight to Go Transportation FALSE 0 0 8.730 8,730 15 Temps R'Us Labor FALSE 2,700 0 0 2,700 16 Notworth Telephone Telephone TRUE 250 0 0 250 17 18 19 20 21