multiply_if_dc

1. Function Name: multiply_if_dc
2. Description: This function takes an Excel table as input and checks the "D/C" column. If the "D/C" value is "D", it multiplies the corresponding amount by -1. Otherwise, it leaves the amount unchanged.
3. Parameters:
   • excel_table: The Excel table containing the data
4. Return Type: It returns the modified Excel table with the "Amount" column adjusted.
5. Exceptions: This function does not raise any exceptions.

Function multiply_if_dc(excel_table As Range) As Range
    ' Get the "D/C" column and the corresponding "Amount" column
    Dim dc_column As Range
    Dim amount_column As Range
    Set dc_column = excel_table.Columns("D/C")
    Set amount_column = excel_table.Columns("Amount")
    
    ' Loop through each row in the "D/C" column
    Dim i As Long
    For i = 1 To dc_column.Rows.Count
        ' Check if the "D/C" value is "D"
        If dc_column.Cells(i).Value = "D" Then
            ' Multiply the corresponding amount by -1
            amount_column.Cells(i).Value = amount_column.Cells(i).Value * -1
        End If
    Next i
    
    ' Return the modified Excel table
    Set multiply_if_dc = excel_table
End Function

Usage Example: Suppose we have an Excel table with the following data:

To use the multiply_if_dc function, enter the following formula in a cell: =multiply_if_dc(A1:B5). This will modify the "Amount" column based on the "D/C" column's values:

The "Amount" column has been multiplied by -1 for rows where the "D/C" value is "D".