IF Functions, Nested functions help!

[Female]

After doing many of these practice sheets, IF functions seem to be the hardest for me. Figuring out the exact formula is difficult to understand. I am hoping you can help me figure out two formulas I need for this particular practice sheet.

Problems:
Insert functions in the Pet Deposit column 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.

Enter nested functions in the Recommendation column to indicate Need to remodel if the apartment is unoccupied and was last remodeled before 2005. For all other apartments, display No change.

I can't seem to upload attachments, but I will upload a photo.

Any and all help is greatly appreciated!

http://imgur.com/tpXXL0J

PracticeSheet5.png

[jewelsharma]

Admins: Website firewall is preventing me from posting a simple solution using IF-AND or NESTED IF. I've tried with codes, without.
Please investigate.

[Special-K]

@jewelsharma: Try placing spaces around any < > signs and repost. This board seems to interpret them as HTML and won't post.

[jewelsharma]

Hi Special-K,
Thanks for the tip.

Hi Female,

Insert functions in the Pet Deposit column 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.

try the following formula in Cell G7:

Please Login or Register  to view this content.

or if you prefer Nested IF, use:

Please Login or Register  to view this content.

Enter nested functions in the Recommendation column to indicate Need to remodel if the apartment is unoccupied and was last remodeled before 2005. For all other apartments, display No change.

try the following formula in Cell H7:

Please Login or Register  to view this content.

or if you prefer Nested IF, use:

Please Login or Register  to view this content.

HTH!