Question

I need help performing calculations using microsoft excel 2013. Can anyone help me?

Answer 1

Sure. whats your confusion?

Answer 2

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 3

I'm not sure how to create a formula to put in the cells.

Answer 4

I think you can use averageif
http://www.techonthenet.com/excel/formulas/averageif.php

Answer 5

Use the IF function.

IF( <condition>, <value if true>, <value if false> )

It depends on what variables you use for the conditions. For the <condition> statement, you'll want "# of bedrooms> 2 AND remodel > 2008". The <true> value would then be "$125", and <false> would be "$75".

Answer 6

yes thats also a way to do it

Answer 7

If you have a column for both number of bedrooms and remodel year (say A and B, respectively), and a third column (C) for the deposit, you'd use
\[\begin{array}{c|c|c|c}
&A&B&C\\
\hline
1&x&y&\text{= IF(AND(A1>2, B1>2008), 125, 75)}
\end{array}\]

Answer 8

@sangya21 it's not "also" a way to do it. Your suggestion would take the average of the cells that satisfy the conditions you place. We don't want the average, we essentially want a yes/no response.

Answer 9

@SithsAndGiggles My bad ;)

Answer 10

A huge thanks to the both of you!!!

Answer 11

@RainRein Anytime :)