QUESTION
Can I create a formula to calculate annual rent? If rent is 2000.00 a month?
ANSWER
The simple answer would be:
=2000.00*12
The more complicated answer would be
=A2*12
Assuming that the monthly rent is stored in cell A2.