Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

easy excel formula

Thread Tools
 
Search this Thread
 
Old 13 June 2003, 04:42 PM
  #1  
what would scooby do
Scooby Senior
Thread Starter
 
what would scooby do's Avatar
 
Join Date: Aug 2002
Location: 52 Festive Road
Posts: 28,311
Likes: 0
Received 0 Likes on 0 Posts
Post

How do I express one number as a percentage of another..

e.g. [2] [1] = 50% as 1 is half of 2
[100] [75] = 75%

I know it's a piece of p1ss but I just can't remember how to do it [img]images/smilies/mad.gif[/img]
Old 13 June 2003, 04:44 PM
  #2  
carl
Scooby Regular
 
carl's Avatar
 
Join Date: May 1999
Posts: 7,901
Likes: 0
Received 0 Likes on 0 Posts
Post

You just do =a/b to get a decimal, then format cells|number type|percentage.
Old 13 June 2003, 04:47 PM
  #3  
what would scooby do
Scooby Senior
Thread Starter
 
what would scooby do's Avatar
 
Join Date: Aug 2002
Location: 52 Festive Road
Posts: 28,311
Likes: 0
Received 0 Likes on 0 Posts
Post

doh - stoopid me ta
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
leg200
Subaru Parts
5
07 October 2015 07:31 AM
Ganz1983
Subaru
5
02 October 2015 09:22 AM



Quick Reply: easy excel formula



All times are GMT +1. The time now is 02:01 AM.