need the excel formula to find 4% of 449.95
 

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

need the excel formula to find 4% of 449.95
 

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

need the excel formula to find 4% of 449.95
 

=.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?

need the excel formula to find 4% of 449.95
 

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?

need the excel formula to find 4% of 449.95
 

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?

need the excel formula to find 4% of 449.95
 

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?

need the excel formula to find 4% of 449.95
 

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?

need the excel formula to find 4% of 449.95
 

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?

need the excel formula to find 4% of 449.95
 

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?