looks like we've got a difference in formulas for the advertising sheet? and I thought we were on the same page... now I'm doubting my teacher.
just to be clear, I used a nested IF function for the advertising sheet. Since we still need to decide the advertising methods for Falmouth (it's default open, anyway) I used this function:
=IF(Values!$B7="No",0,IF(Values!B$21="Yes",Advertising!B7,0))
and for the totals sheet I used:
=IF(Values!$B7="Yes",Totals!H7,0)
can anyone tell me if they got it differently?