ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Usenet Groups > Excel 2007 Help
Percentage formula Percentage formula
Register FAQ Forum Rules Members List Calendar Search Today's Posts Mark Forums Read

Notices
Hi All,
The big green guy here, just wanted to let you all know that we now have the reputation system in place, the reputation system allows you to give a visible pat on the back to those that have helped you or whose information has been helpful.

You will see an icon in every post (Light Blue scales), click this to give the reputation point to whom you think deserves it, a green square appears for a reputation with more and more adding over time.Pretty soon you will see a string of green squares appear in the top right of your posts as your reputation grows and your forum presence!

Good Luck!
The Hulkster!

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 09-05-2008, 03:20 PM
Dxiong Dxiong is offline
Registered User
  
Join Date: 04 Sep 2008
Location: Wisconsin
Posts: 8
Dxiong is on a distinguished road
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
Last edited by VBA Noob; 09-05-2008 at 03:24 PM.
Reply With Quote
  #2  
Old 09-05-2008, 03:29 PM
NBVC's Avatar
NBVC NBVC is online now
Forum Moderator
  
Join Date: 06 Dec 2006
Location: Mississauga, CANADA
Posts: 7,887
NBVC will become famous soon enough NBVC will become famous soon enough
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. Finding one that works for you is the challenge!

Please read the Forum Rules: Rules
Reply With Quote
  #3  
Old 09-05-2008, 03:31 PM
davesexcel's Avatar
davesexcel davesexcel is offline
Forum Moderator
  
Join Date: 19 Feb 2006
Location: Cochrane,Alberta
Posts: 3,516
davesexcel will become famous soon enough davesexcel will become famous soon enough
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
__________________
Dave
Please read the Forum Rules before posting!
Reply With Quote
  #4  
Old 09-05-2008, 03:32 PM
Justinetme Justinetme is offline
Registered User
  
Join Date: 21 Dec 2007
Posts: 26
Justinetme is on a distinguished road
What do you mean it doesn't work? Are you getting a number back or an error?

Justine
Reply With Quote
  #5  
Old 09-05-2008, 03:35 PM
Dxiong Dxiong is offline
Registered User
  
Join Date: 04 Sep 2008
Location: Wisconsin
Posts: 8
Dxiong is on a distinguished road
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
Reply With Quote
  #6  
Old 09-05-2008, 04:32 PM
Dxiong Dxiong is offline
Registered User
  
Join Date: 04 Sep 2008
Location: Wisconsin
Posts: 8
Dxiong is on a distinguished road
Wink 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
Reply With Quote
  #7  
Old 09-05-2008, 05:00 PM
shg's Avatar
shg shg is offline
Forum Moderator
  
Join Date: 21 Jun 2007
Location: Dallas, Texas
Posts: 6,160
shg will become famous soon enough shg will become famous soon enough
Replace the number with a cell reference.
Reply With Quote
  #8  
Old 09-05-2008, 05:40 PM
Dxiong Dxiong is offline
Registered User
  
Join Date: 04 Sep 2008
Location: Wisconsin
Posts: 8
Dxiong is on a distinguished road
Wink 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
Reply With Quote
  #9  
Old 09-05-2008, 06:36 PM
shg's Avatar
shg shg is offline
Forum Moderator
  
Join Date: 21 Jun 2007
Location: Dallas, Texas
Posts: 6,160
shg will become famous soon enough shg will become famous soon enough
=F3 * (1 + A1), where A1 contains the percentage change.
Reply With Quote
  #10  
Old 09-05-2008, 06:48 PM
Dxiong Dxiong is offline
Registered User
  
Join Date: 04 Sep 2008
Location: Wisconsin
Posts: 8
Dxiong is on a distinguished road
Thanks so much for your help!
It works now...
dxiong
Reply With Quote
Reply

Bookmarks

New topics in Excel 2007 Help

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Regression in formulas (Formula too long) DRoyLenz Excel Worksheet Functions 7 01-23-2008 02:20 PM
Percentage Formula Assistance kingsolo Excel Worksheet Functions 2 05-11-2007 01:34 AM
Percentage Formula for Tax Split? minker Excel General 2 04-28-2007 07:31 AM
help with percentage formula pumperley Excel - New Users 6 10-12-2006 10:33 PM


All times are GMT -4. The time now is 05:52 PM.

Contact Us - ExcelTip.com - Archive - Top

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0