Question

Instructions: Insert functions in the Pet Deposit column of the Summary worksheet to calculate the required pet deposit for each unit. If the unit has two or more bedrooms and was remodeled after 2008 the deposit is $125, if not it is $75.

Answer 1

The problem ask to insert a function in the Pet Deposit column of the summary worksheet to calculate the required pet deposit for each unit and if the unit has to or more bedroom and has a deposit $125 if not $75 so the function would =IF(AND(E7="no",F7<2005),"Need to remodel","No change") I hope you are satisfied with my answer