Hello, I am having trouble with the below problem. I have a formula for "Yes" to a locker room. However, I am unable to calculate if the member does...

Hello,I am having trouble with the below problem. I have a formula for "Yes" to a locker room. However, I am unable to calculate if the member does not have a locker room. Insert a function in cell E5 to calculate total amount. The function should add the cost of membership plus, if applicable, the locker fee. The locker column displays Yes for clients that rent lockers.This is the function I have so far... =IF(D5="YES",75+C5,B22)