need the excel formula to find 4% of 449.95

K

Kenny

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

Tyro

=449.95 * 4%

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

Tyro
 
T

Todd S

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

=SUM(499.95*0.04)
 
T

Tyro

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
 
J

JLatham

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 :)
 
M

Mike H

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%
 
G

Gord Dibben

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
 
Top