"If" statements for multiple dates and date ranges that correspond to different formulas

I have a bunch of "If And" statements, as I want to apply a certain formula depending on date range (it's a cost forecasting model by month - so, there would be a certain formula if it's before a certain date, if it's between certain dates, and after a certain date). The formula works fine until I try "book-end" it with a simple "if" statement at the beginning and at the end (e.g., if the date is less than x, then it's y calculation; if the date is more than B date, then use C calc). When I add that logic in, I get a "#VALUE" message.

Below is the formula itself, and I have attached the spreadsheet for reference. Any help would be greatly appreciated!!

=IF(AND(S$30>=$D$30,S$30<$E$30),$M$32*$D32,IF(AND(S$30>=$E$30,S$30<$F$30),$M$32*$E32,IF(AND(S$30>=$F$30,S$30<$G$30),$M$32*$F32,IF(AND(S$30>=$G$30,S$30<$H$30),$M$32*$G32)*0)))