Yorkshire Divers

Deep Blue Technical
Go Back   YD Scuba Diving Forums > Non-Diving Related Forums > Technology
Percentages in Excel Percentages in Excel
User Name
Password

Welcome to the YD Scuba forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

Technology: Discuss Percentages in Excel in the Non-Diving Related Forums forums: We're having a complete brain dead moment in our office at the mo and neither of us can work out ...

Reply
Page 1 of 2 1 2 >
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-09-05, 02:52 PM
littleH's Avatar
Senior Member
  

Join Date: Mar 2005
Location: Keighley - as featured on www.chav-town.co.uk
Posts: 511
littleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annually
Percentages in Excel
We're having a complete brain dead moment in our office at the mo and neither of us can work out how we get a percentage.

we want for example cell H2 as a percentage of cell H1 so we've put in =H2/H1*100 but it's giving us 93% and it should be 7% how do we do it?
__________________
you're not a fish - so put your reg in or you'll get a gob full of water!

Friends don't let friends drink and take home ugly men


It's cool to be DiFF
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 06-09-05, 02:54 PM
kath2407's Avatar
Swims with More Seals
  

Join Date: Jul 2004
Location: Leeds
Posts: 1,983
kath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold water
H1/H2 then click on the % sign at the top - stops you having to do the X100 bit
__________________
why shouldn't divers have a dirty sense of humour - we go down, we get wet, we wear rubber!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 06-09-05, 02:54 PM
Garf's Avatar
Chimp 2
  

Join Date: Aug 2003
Location: West Sussex
Posts: 6,152
Garf was born with gillsGarf was born with gillsGarf was born with gillsGarf was born with gillsGarf was born with gillsGarf was born with gillsGarf was born with gillsGarf was born with gillsGarf was born with gillsGarf was born with gillsGarf was born with gills
=(cell1/cell2)*100

will work just fine, make sure you have the rexult cell formatted correctly
__________________
Garf
Postatem obscuri lateris nescitis.
www.teamfoxturd.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 06-09-05, 02:58 PM
littleH's Avatar
Senior Member
  

Join Date: Mar 2005
Location: Keighley - as featured on www.chav-town.co.uk
Posts: 511
littleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annually
Quote:
Originally Posted by Garf
=(cell1/cell2)*100

will work just fine, make sure you have the rexult cell formatted correctly
we've tried everything....the cells are formatted in general and we either get 93% or 107%


.......ummm do we have to -100?
__________________
you're not a fish - so put your reg in or you'll get a gob full of water!

Friends don't let friends drink and take home ugly men


It's cool to be DiFF
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 06-09-05, 03:04 PM
kath2407's Avatar
Swims with More Seals
  

Join Date: Jul 2004
Location: Leeds
Posts: 1,983
kath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold water
Ring me and give me some "proper" numbers so that I can work through it with you

K
__________________
why shouldn't divers have a dirty sense of humour - we go down, we get wet, we wear rubber!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 06-09-05, 03:06 PM
Member
  

Join Date: Apr 2005
Posts: 324
BertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the sea
Quote:
Originally Posted by littleH
We're having a complete brain dead moment in our office at the mo and neither of us can work out how we get a percentage.

we want for example cell H2 as a percentage of cell H1 so we've put in =H2/H1*100 but it's giving us 93% and it should be 7% how do we do it?

What numbers do you have in each cell mate?

Jamie
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 06-09-05, 03:08 PM
littleH's Avatar
Senior Member
  

Join Date: Mar 2005
Location: Keighley - as featured on www.chav-town.co.uk
Posts: 511
littleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annuallylittleH dips toes in sea annually
Quote:
Originally Posted by kath2407
Ring me and give me some "proper" numbers so that I can work through it with you

K
Pass the hair dye......

my boss loves you. neither of us understand it but we know how to do it

have some green

the answer was =(cell1/cell2)/cell1 % (the & is the button at the top)


thanks all
H xx
__________________
you're not a fish - so put your reg in or you'll get a gob full of water!

Friends don't let friends drink and take home ugly men


It's cool to be DiFF
Last edited by littleH : 06-09-05 at 03:11 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 06-09-05, 03:11 PM
Finless's Avatar
Finless: You couldn't invent him...
  

Join Date: Apr 2003
Location: Bexhill, East Sx.
Posts: 14,523
Finless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the water
Quote:
Originally Posted by littleH
We're having a complete brain dead moment in our office at the mo and neither of us can work out how we get a percentage.

we want for example cell H2 as a percentage of cell H1 so we've put in =H2/H1*100 but it's giving us 93% and it should be 7% how do we do it?
It works fine on my version of Excel (I use Lotus all the time so needed to check the syntax you had used). Are you sure you have checked that what you actually typed into your spreadsheet is what you have mentioned in your post?
__________________
Citius, Altius, Fortius? No: Lower, Slower, Fatter.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 06-09-05, 03:25 PM
Member
  

Join Date: Apr 2005
Posts: 324
BertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the seaBertieB paddles in the sea
Quote:
Originally Posted by littleH
Pass the hair dye......

my boss loves you. neither of us understand it but we know how to do it

have some green

the answer was =(cell1/cell2)/cell1 % (the & is the button at the top)


thanks all
H xx
There is more than one answer to this. Without knowing what numbers you are working with and what you are trying to do with them, its imposs to specify what is wrong with your formula.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old 06-09-05, 03:27 PM
tootricky's Avatar
One of Digger's Angels
  

Join Date: May 2005
Location: Gosport, Hants
Posts: 1,410
tootricky is a scuba diver - cold watertootricky is a scuba diver - cold watertootricky is a scuba diver - cold watertootricky is a scuba diver - cold watertootricky is a scuba diver - cold watertootricky is a scuba diver - cold watertootricky is a scuba diver - cold watertootricky is a scuba diver - cold watertootricky is a scuba diver - cold watertootricky is a scuba diver - cold watertootricky is a scuba diver - cold water
Quote:
Originally Posted by littleH
Pass the hair dye......

my boss loves you. neither of us understand it but we know how to do it

have some green

the answer was =(cell1/cell2)/cell1 % (the & is the button at the top)


thanks all
H xx
Might have solved your problem but it's got me confused as hell. AFAIUI, it makes no sense!
__________________
Quote:
Originally Posted by Digger
We on the other hand, are an elite team of heart breakers for the elderly It will be like Charlie's Angels, but we will despatch our victims with heart attacks and strokes.
Don't wrestle with a pig. You'll only get as dirty as the pig & the pig likes it
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply
Page 1 of 2 1 2 >

« PC Power Units | Help with ADSL router and my network, please »

Thread Tools
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
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Sponsored Links

Yorkshire Divers - RSS Feed
All times are GMT +1. The time now is 07:21 AM.
Powered by vBulletin
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.2.0
Trademark and all rights reserved : © YD.com Ltd (2006)
YD.com Ltd (Registered in England - 05886696)
Other sites : Golf Clubs | New Premiership Football Kits | MP3 Portable Players | MP3 Players For Sale | Replica Football Kits | Cheap Football Boots

Advertise - Contact Us - Yorkshire Divers - Sitemap - Privacy Statement - Terms & Conditions - Top
Forums Directory