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

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?
 
S

Shane Devenshire

Hi,

=12*Monthly

or

=12*1200

or if 1500 is in A1 then in a blank cell

=A1*12
 
G

Gord Dibben

How would you do it using pencil and paper?

=months x monthly rate

=12* 1500


Gord Dibben MS Excel MVP
 
M

maria

Thank you so much for your assistance, but should I also use something like
this
=SUM(A1*12)?
 
G

Gord Dibben

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
 
D

David Biddulph

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
 
M

maria

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
 
M

maria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top