Excel | Accounting homework help

1. Some vendors have agreed on an industry-standard penalty of $45 on all past due accounts regardless of the past due amount or number of days past due. These vendors are iden�fied by the value TRUE in the corresponding row of column C. Write a formula in column H, which can be copied down the column, lis�ng the penalty for the corresponding account: $45 for vendors that are par�cipa�ng in this standard penalty and $0 for all other vendors. Only vendors that are owed past due balances are listed on this sheet.

Fixe Fee Penalty value is in the Cell B2, so any�me that we need to reference this value we will use the absolute reference $B$2 So, in this case if applied Fixed Penalty the Value is 45 ($B$2) otherwise will be Zero

The excel formula in column H is:

=IF(C9,$B$2,0)

For the column I (90 Days Penalty) in the exercise topic 3 says: