Need help using the nested IF function with multiple conditions and absolute references

[jord9977]

Hello I am doing some homework and I need help with the following question,

"Use a nested IF function in cell G7 to figure out the total annual cost for each club member,
including the annual membership fee, the Line Priority Pass and Individual Lessons (hint:
you will need to use multiple conditions and absolute references to accomplish this). Copy
the formula down to cell G21."

I know how to use the basic IF function but this one has got me a little confused, I have attached my data sheet.

Thank you so much in advance!
Excel..PNG

[jord9977]

Or here is the excel file itself. Thanks again!

[sktneer]

May be this......

Please Login or Register  to view this content.

[jord9977]

Thank you very much, this is what I was looking for seems to work.

[kagest1]

Thanksssssss

[sktneer]

Glad to help you. Thanks for the feedback.
If that takes care of your question, please mark your thread as solved.