I Know what I need to accomplish, but I do not know how to write the correct code.
If E20 is "Yes", then 3 formulas need to run in 3 different cells.
If No, then it is just one formula in one cell. See below.
Private Sub Worksheet_Change(ByVal Target As Range)
‘FINAL PAY CALCULATOR
If Target.Address <> "$E$20" Then Exit Sub
If Target.Value = "Yes" Then (E21=G20), C28=G20 and C20=E20-(C21*C22)
ElseIf Target.Value = "No" Then (E21= C20+(C21*C22)
Any assistance or insight would be greatly appreciated