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?
--
Maria A Adams

Hi Maria,

To calculate the annual rent amount based on the monthly rent, you can use a simple multiplication formula in Microsoft Excel. Here are the steps:

1. In your "Estimated Diner Expenses" worksheet, select the cell where you want to display the annual rent amount.
2. Type the following formula into the cell: =1500*12 (assuming that the monthly rent is $1500).
3. Press Enter on your keyboard.
4. The cell should now display the annual rent amount, which in this case would be $18,000.

That's it! This formula multiplies the monthly rent by 12 to calculate the annual rent amount. You can use this same formula to calculate the annual amount for any other monthly expenses you have in your worksheet.

Hi,

=12*Monthly

or

=12*1200

or if 1500 is in A1 then in a blank cell

=A1*12


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"maria" wrote:

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?
--
Maria A Adams

How would you do it using pencil and paper?

=months x monthly rate

=12* 1500


Gord Dibben MS Excel MVP

On Wed, 11 Mar 2009 16:18:04 -0700, maria
wrote:

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?

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


"Shane Devenshire" wrote:

Hi,

=12*Monthly

or

=12*1200

or if 1500 is in A1 then in a blank cell

=A1*12


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"maria" wrote:

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?
--
Maria A Adams

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


On Wed, 11 Mar 2009 16:37:01 -0700, maria
wrote:

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

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
--
David Biddulph

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

Hi,

=12*Monthly

or

=12*1200

or if 1500 is in A1 then in a blank cell

=A1*12


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"maria" wrote:

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?
--
Maria A Adams

Thank you for your assistance.
--
Maria A Adams


"David Biddulph" wrote:

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
--
David Biddulph

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

Hi,

=12*Monthly

or

=12*1200

or if 1500 is in A1 then in a blank cell

=A1*12


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"maria" wrote:

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?
--
Maria A Adams

Thank you for your assistance.
--
Maria A Adams


"Gord Dibben" wrote:

How would you do it using pencil and paper?

=months x monthly rate

=12* 1500


Gord Dibben MS Excel MVP

On Wed, 11 Mar 2009 16:18:04 -0700, maria
wrote:

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?