How to display a response depending on which check box has been selected over 3 columns

Hi guys,

I hope I'm in the right forum area for my question.

I'm quite new to excel & I'm trying to develop a basic invoice which will auto populate an item amount dependent on the check box selected. I have managed to figure out how to display the result from a single column if it is selected, but have been unable to find any information (that I could understand) about how to display results in the same cell from either the second or third column if they are selected instead.

I have three columns titled: Attended $100 (E17), No Show $25 (E18), & No Show Unpaid (E19) (no amount to display - $0 or blank), the fourth column (E20) I want to display the $dollar amount of the selected check box so I can then auto sum for a final billable amount.

I have cell linked each check box to show True/False, but not sure how to apply that to a workable formula, or even what direction I need to move in now - nested IF? Vlookup? Please, please help!


excel example.png

I just KNEW it was going to be something so simple

Thank you so very much, Tony