LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default conversion formula

hi I work with Excel 2000. I have a spreadsheet that holds the pass marks
for students displayed like so
27-Apr-07 El Health & Safety 13 93/130 72%
29-May-07 First Aid 18 124/180 69%
08-Jun-07 Geography 19 156/190 82%
this shows date, name of course, how many students sat the exam, what their
pass mark was and then the pass mark as a persentage.
The person who set up this spreadsheet obviously has better math skills than
me as she was just typint in the pass mark persentage.

I need to know if there is a formula that will automatically show me what
the persentage rate is. (my fingers are crossed in the hope that there is)
Thank you for reading my post. Hopefully you can answer my querie
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Currency Conversion Formula pantherguy Excel Worksheet Functions 2 November 22nd 06 09:31 PM
Conversion Formula dawg Excel Worksheet Functions 3 November 11th 06 11:00 PM
Automatic Formula to Value Conversion workerboy Excel Worksheet Functions 1 August 8th 06 07:59 PM
Need Formula for Date Conversion Lyle Excel Worksheet Functions 4 March 31st 05 12:09 AM
Conversion lookup formula Manos Excel Worksheet Functions 2 November 12th 04 07:53 AM


All times are GMT +1. The time now is 09:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"