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
Last edited by VBA Noob; 09-05-2008 at 02:24 PM.
What do you mean by "doesn't work"? Is it wrong answer, gives an error, what?.. that seems to be a valid formula...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
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
What do you mean it doesn't work? Are you getting a number back or an error?
Justine
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
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
Replace the number with a cell reference.
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
=F3 * (1 + A1), where A1 contains the percentage change.
Thanks so much for your help!
It works now...
dxiong
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..
Last edited by jmdencris; 10-28-2011 at 11:35 PM.
try this one..
=F3*(1+ 100%)+(1+ 50%)
tnx..
3 years old thread. I doubt the OP still has a problem...
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks