corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Percentage working out on excel?!


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Percentage working out on excel?!
Munchie
Member
Registered: 17th Jul 01
Location: I swap goats for mobile phones
User status: Offline
23rd Feb 04 at 18:02   View User's Profile U2U Member Reply With Quote
anybody know the forumla?
CorsaLad16v
Member
Registered: 5th Mar 03
Location: Sheffield UK Drives: VW Golf
User status: Offline
23rd Feb 04 at 18:03   View User's Profile U2U Member Reply With Quote
i did when i did IT last year 4got it all now
Munchie
Member
Registered: 17th Jul 01
Location: I swap goats for mobile phones
User status: Offline
23rd Feb 04 at 18:04   View User's Profile U2U Member Reply With Quote
find out!
CorsaLad16v
Member
Registered: 5th Mar 03
Location: Sheffield UK Drives: VW Golf
User status: Offline
23rd Feb 04 at 18:11   View User's Profile U2U Member Reply With Quote
1. Click the cell where you would like the percentage to be displayed.

2. Type the following into the cell: =A1/A2 . (Change A1 and A2 to the cells which have the values you want to find the percentage for. For example, if you wanted to find out the percent cell A1 is of A2, then type =A1/A2 .)

3. Press Enter.

4. Right-click the cell which you just entered this formula into, and select "Format Cells..." from the menu that appears.

5. Click the "General" tab.

6. From the "Category:" list, click "Percentage".

7. Click OK.

8. Now, the percentage of the two cells you used in the formula will be displayed in percent format.
Munchie
Member
Registered: 17th Jul 01
Location: I swap goats for mobile phones
User status: Offline
23rd Feb 04 at 18:58   View User's Profile U2U Member Reply With Quote
say u wanted it for more data? wat do ya type in den?
CorsaLad16v
Member
Registered: 5th Mar 03
Location: Sheffield UK Drives: VW Golf
User status: Offline
23rd Feb 04 at 19:10   View User's Profile U2U Member Reply With Quote
i got kicked off my IT course so i only know the basic stuff i'm sure sum1 will know tho
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Online
23rd Feb 04 at 19:18   View Garage View User's Profile U2U Member Reply With Quote
Drag the corner of the cell down past the others?
Rob
Member
Registered: 9th Jul 01
Location: hull
User status: Offline
23rd Feb 04 at 20:00   View User's Profile U2U Member Reply With Quote
ain't it SUM=(WHATEVER) enter?
Munchie
Member
Registered: 17th Jul 01
Location: I swap goats for mobile phones
User status: Offline
23rd Feb 04 at 20:39   View User's Profile U2U Member Reply With Quote
I USED AN ALTERNATIVE METHOD TO ACHEIVE THE SAME RESULT!!!! CHEERS NEWAY MATE

 
New Topic
New Poll

Corsa Sport » Message Board » Off Day » Percentage working out on excel?! 23 database queries in 0.0108871 seconds