What kind of formula would I use for an annual amount for rent?

  • Thread starter Thread starter maria
  • Start date Start date
M

maria

Could someone please help me, I am trying to figure out what type of formula
I should use in my "Estimated Diner Expenses" worksheet for school. For
example:
Monthly Rent is 1500 what would be the formula to use to figure the Annual
Rent amount?
 
How would you do it using pencil and paper?

=months x monthly rate

=12* 1500


Gord Dibben MS Excel MVP
 
Thank you so much for your assistance, but should I also use something like
this
=SUM(A1*12)?
 
The SUM is not needed in this case since you are multiplying two numbers.

No summing involved.

Don't overwork the SUM function..........too many people use it when not
necessary.

=123 + 456 is the same as =SUM(123 + 456) or =SUM(123,456)


Gord
 
Thank you for your assistance.
--
Maria A Adams


David Biddulph said:
No you shouldn't. If you look up the SUM function in Excel help you will
see that it is a function for giving you the SUM of a group of numbers, in
other words adding them together.

You haven't asked the function to add anything to A1*12, so you don't need
the SUM function. If you want A1*12, thye formula is =A1*12
Click to expand...
 
Thank you for your assistance.
--
Maria A Adams


Gord Dibben said:
How would you do it using pencil and paper?

=months x monthly rate

=12* 1500


Gord Dibben MS Excel MVP
Click to expand...
 
Back
Top