The step you are missing in the simple formula is to read Mike's suggestion
and do what he said.

The answers are $5,732.40 in A2 and $4,737.90 in A3.
I don't understand where you are getting $57 for A2. You didn't by any
chance multiply by 1.02%, rather than multiplying by 1.02, did you?
--
David Biddulph

"Lin242" wrote in message
...
Hello David, and thanks, yes I agree, but let me give you an example then
as
you suggest. My worksheet is simply cells full of dollar amounts, Columns
A2
- H2, 15 rows down. For example A2 appears: $5,620, A3 is $4,645 and so
on
across and down.

When I apply Mike's formula what I get in each cell is not the addition of
2% but the action represented addition, such as $57 for A2, what I want is
that it will add it on to $5,620. Am I missing a step in the simple
formula?

Thanks!

Jacinthe, agreed, one must give credit where credit is due :), thanks
again!
--
Lin242


"David Biddulph" wrote:

If you multiply a number by 1.02, that "is" adding 2% to the original
amount, as 1.02 is what you get when you add 2% to the number 1.
Why don't you try Mike's suggestion, and see what numbers you get?

If you are still struggling, give us some examples of:
What number you started with,
What operations you applied to that number,
What result you got,
What number you expected.
--
David Biddulph

"Lin242" wrote in message
...
I really appreciate your time, but even putting 1.02 in an empty box and
following the instructions you gave simply gives the actual percentage
amount, it doesn't ADD it to the existing numbers which is what I
really
want
to do.

I will try your way tomorrow Jacinthe, I am not a regular Excel user,
so
the
original instructions from Don made no sense to me. I'll see if yours
are
a
bit clearer. It's frustrating because it appears like it should be so
simple
and it isn't. :)
--
Lin242


"Jacinthe" wrote:

Possibly the simplest solution. Except that OP specified that she
wants
all
future entries to do this automatically. This solution would only fix
current entries.

"Mike H" wrote:

Lyn,

Put 1.02 in a cell and copy it. Select your range then

Edit|Paste Special
Select Multiply
Click OK

Mike