formulas

[Chrissy]

I need help with an excel formula. I put in the formula =A1*.25. When I type
100 in the A1 block it removes the formula and leave the number 100, when it
should calculate 75. Am I doing something wrong?

[Jim Thomlinson]

Put that formula in Cell B1 and then add 100 to cell A1. Now in Cell A1 you
will have 100 and in Cell B1 you will have 25. I am not too sure where you
get the 75 from so if I am missing something just let me know...
--
HTH...

Jim Thomlinson


"Chrissy" wrote:

> I need help with an excel formula. I put in the formula =A1*.25. When I type
> 100 in the A1 block it removes the formula and leave the number 100, when it
> should calculate 75. Am I doing something wrong?

[Chrissy]

Jim,

Thanks....cell B1 is A1*.75, to get 75% off A1 value!! it works....

Thanks

Chrissy

"Jim Thomlinson" wrote:

> Put that formula in Cell B1 and then add 100 to cell A1. Now in Cell A1 you
> will have 100 and in Cell B1 you will have 25. I am not too sure where you
> get the 75 from so if I am missing something just let me know...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Chrissy" wrote:
>
> > I need help with an excel formula. I put in the formula =A1*.25. When I type
> > 100 in the A1 block it removes the formula and leave the number 100, when it
> > should calculate 75. Am I doing something wrong?