Help with proper syntax for an IF(AND formula construct

Working on a spreadsheet for my CSE class, theres one cell that I just can't get to work.

Cell C21 is either W(For water park) or Z(for Zoo)
Cell C23 is either H(Hot summer) or C(Cool Summer)

Cell C4 is $500 for daily operating cost of Water park.
Cell C7 is $3000 for daily operating cost of Zoo.

Cell B17 is "150" for days each park is open during the year.

If the chosen park to build is a waterpark, and it is hot, operating costs increase by 5%.
If the chosen park is Zoo, and it is hot, operating costs reduce by 3%.

The zoo however, has a 365 day annual cost because the animals still need fed, the water park only has the 150 days.

This is the formula I came up with, and I can't get it to work for the life of me, Its frustrated me beyond belief

=IF(AND(C21="W",C23="C"),C4*B17,C4*B17*1.05)IF(AND(C21="Z",C23="C"),C7*365,(C7*B17*0.97)+C7*(365-B17))


Any help would be so very appreciated, thanks for looking

Hi Indians and welcome to the forum,

In your CSE class did they show you the "Evaluate" dialog? On the Formula tab click on the Evaluate Icon. Then step by step you can go through your formula to see what it is doing.

I hope teaching you how to debug these formulas will be better than giving you an answer....

Look at http://www.excel-user.com/2010/10/ev...xcel-2010.html for an explanation.

Have you stepped through the EVALUATE dialog and look at each step, to see if it is doing what you are wanting?

You really need to calculate it by hand and then see if each step in the evaluate does what you intended. I always find a missing parenthesis or comma somewhere that then makes sense later.

You really need to debug the formula yourself to learn how to do it. I'd hate to have you get a good grade in this class without learning how to debug formulas.

the structure of the if formula is wrong
=IF(AND(C21="W",C23="C"),C4*B17,C4*B17*1.05)IF(AND(C21="Z",C23="C"),C7*365,(C7*B17*0.97)+C7*(365-B17))
it should be like this
=IF(AND(C21="W",C23="C"),do something here,IF(AND(C21="Z",C23="C"),do something else here))

erithra68 welcome to the forum

1. Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

2. What on earth is Crystal Park? Please explain in your new thread

Click HOME on the side bar menu or, click FORUM on the top menubar.
Click the sub-rorum: Excel Formulas & Functions
Click the "POST NEW THREAD" button