I am trying to do homework on a paper that needs to be turned in on Sunday.
Can someone please help with this formula?

=449.95 * 4%

That formula produces 17.998
The amount of 449.95 is multiplied (*) by 4%.

Tyro

"Kenny" wrote in message
...
I am trying to do homework on a paper that needs to be turned in on Sunday.
Can someone please help with this formula?

=.04 * 449.95

If the 449.95 is in A1 =.04 * A1



Gord Dibben MS Excel MVP

On Sat, 8 Mar 2008 15:16:01 -0800, Kenny
wrote:

I am trying to do homework on a paper that needs to be turned in on Sunday.
Can someone please help with this formula?

Why not multiply by 4% which is more intuitive than .04

Regards,
Tyro

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
=.04 * 449.95

If the 449.95 is in A1 =.04 * A1



Gord Dibben MS Excel MVP

On Sat, 8 Mar 2008 15:16:01 -0800, Kenny
wrote:

I am trying to do homework on a paper that needs to be turned in on
Sunday.
Can someone please help with this formula?

Kenny, try this out. You can also replace 499.95 with a cell reference.

=SUM(499.95*0.04)


"Kenny" wrote:

I am trying to do homework on a paper that needs to be turned in on Sunday.
Can someone please help with this formula?

SUM? SUM is used to sum (add) numbers as in =SUM(A1:A10000) to add 10,000
numbers. How is SUM(499.95*0.04) better than =499.95*4%? There is no SUM,
just a multiplication.

Tyro

"Todd S" <Todd wrote in message
...
Kenny, try this out. You can also replace 499.95 with a cell reference.

=SUM(499.95*0.04)


"Kenny" wrote:

I am trying to do homework on a paper that needs to be turned in on
Sunday.
Can someone please help with this formula?

While not the 'tightest' formula in the world, Todd S's suggestion will work.
Like so many, he may have even been led to believe that SUM() is a REQUIRED
'statement' within a cell by the examples put forth by the writers of the
Excel (not much) Help files.

As far as Gord's suggestion of .04 vs 4%: it's a matter of personal style.
And the fact that 4% is a human convention of expressing a mathmatical value
that is actually .04 Personal style is something I've found that works its
way into many things I've participated in during my lifetime - some things
that you'd think are quite structured, such as computer programming, air
traffic control, weather radar installation and tuning, and even writing
Excel formulas :)

"Tyro" wrote:

SUM? SUM is used to sum (add) numbers as in =SUM(A1:A10000) to add 10,000
numbers. How is SUM(499.95*0.04) better than =499.95*4%? There is no SUM,
just a multiplication.

Tyro

"Todd S" <Todd wrote in message
...
Kenny, try this out. You can also replace 499.95 with a cell reference.

=SUM(499.95*0.04)


"Kenny" wrote:

I am trying to do homework on a paper that needs to be turned in on
Sunday.
Can someone please help with this formula?

I agree and suspect that most of us doing such a sum on a calculator would
input 449.95*.04 and not fumble around trying to multiply by 4%

"JLatham" wrote:

While not the 'tightest' formula in the world, Todd S's suggestion will work.
Like so many, he may have even been led to believe that SUM() is a REQUIRED
'statement' within a cell by the examples put forth by the writers of the
Excel (not much) Help files.

As far as Gord's suggestion of .04 vs 4%: it's a matter of personal style.
And the fact that 4% is a human convention of expressing a mathmatical value
that is actually .04 Personal style is something I've found that works its
way into many things I've participated in during my lifetime - some things
that you'd think are quite structured, such as computer programming, air
traffic control, weather radar installation and tuning, and even writing
Excel formulas :)

"Tyro" wrote:

SUM? SUM is used to sum (add) numbers as in =SUM(A1:A10000) to add 10,000
numbers. How is SUM(499.95*0.04) better than =499.95*4%? There is no SUM,
just a multiplication.

Tyro

"Todd S" <Todd wrote in message
...
Kenny, try this out. You can also replace 499.95 with a cell reference.

=SUM(499.95*0.04)


"Kenny" wrote:

I am trying to do homework on a paper that needs to be turned in on
Sunday.
Can someone please help with this formula?

I just learned never to trust Excel's idea of "percent".

Enter 2 in a cell and format to percent return 200%

Years ago I started entering .02 and have not stopped.

Habits die hard.


Gord

On Sat, 8 Mar 2008 23:20:00 -0800, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

While not the 'tightest' formula in the world, Todd S's suggestion will work.
Like so many, he may have even been led to believe that SUM() is a REQUIRED
'statement' within a cell by the examples put forth by the writers of the
Excel (not much) Help files.

As far as Gord's suggestion of .04 vs 4%: it's a matter of personal style.
And the fact that 4% is a human convention of expressing a mathmatical value
that is actually .04 Personal style is something I've found that works its
way into many things I've participated in during my lifetime - some things
that you'd think are quite structured, such as computer programming, air
traffic control, weather radar installation and tuning, and even writing
Excel formulas :)

"Tyro" wrote:

SUM? SUM is used to sum (add) numbers as in =SUM(A1:A10000) to add 10,000
numbers. How is SUM(499.95*0.04) better than =499.95*4%? There is no SUM,
just a multiplication.

Tyro

"Todd S" <Todd wrote in message
...
Kenny, try this out. You can also replace 499.95 with a cell reference.

=SUM(499.95*0.04)


"Kenny" wrote:

I am trying to do homework on a paper that needs to be turned in on
Sunday.
Can someone please help with this formula?