# Excel 2007 : Percentage formula

1. ## Percentage formula

Hi,
Can someone please tell me why the formula =F3*1.50 doesn't work in excel.
what I'm trying to do is that the cost plus 50%. I need this formula to be copy to more than one cell. so whatever the cost is in F3 times 100% plus 50%.
Please help dxiong  Register To Reply

2. What do you mean by "doesn't work"? Is it wrong answer, gives an error, what?.. that seems to be a valid formula...  Register To Reply

3. So the formula works? but when you drag it down the cell range changes??
=\$f\$3*1.5 will stop the range from changing when you drag the formula  Register To Reply

4. What do you mean it doesn't work? Are you getting a number back or an error?

Justine  Register To Reply

5. It works now..ah...just forgot to adjust the cell to be big enough for the numbers.. I kept getting alot of the ## signs..
Thanks so much for all the help dxiong  Register To Reply

6. ## Help with percentage not fixed formula

Hi this formula is what I have B4*1.50, which in this case its fixed at 50% everytime. What I want is the percentage is not fixed and it could be any percentage. What can I put into this formula so that it can take any percentage?
Help dxiong  Register To Reply

7. Replace the number with a cell reference.  Register To Reply

8. ## percentage formula help

Is the cell reference the "\$" sign? I tried to do that and it didn't work..please let me know how you do it?

Thanks so much dxiong  Register To Reply

9. =F3 * (1 + A1), where A1 contains the percentage change.  Register To Reply

10. Thanks so much for your help!
It works now...
dxiong   Register To Reply

11. ## Re: Percentage formula

ecause =F3*1.50 simply times the number of F3 by 1.50 and 1.50 is not a percent

try this one..

=F3*(1+ 100%)+(1+ 50%)

tnx..  Register To Reply

12. ## Re: Percentage formula

try this one..

=F3*(1+ 100%)+(1+ 50%)

tnx..  Register To Reply

13. ## Re: Percentage formula

3 years old thread. I doubt the OP still has a problem...  Register To Reply

14. ## Re: Percentage formula Originally Posted by Dxiong Hi,
Can someone please tell me why the formula =F3*1.50 doesn't work in excel.
what I'm trying to do is that the cost plus 50%. I need this formula to be copy to more than one cell. so whatever the cost is in F3 times 100% plus 50%.
Please help dxiong

Here it is / Try this:

=SUM(F3*1.5)

(it worked for me)  Register To Reply