ECDL help

  barrie_g 12:43 24 Mar 2003
Locked

hi I'm currently doing my ecdl and the file is not up to much it asks in one of the mock exams for you to calculate the percentage of a range of a range of cells in exel could someone please give me an example formula for doing this,
thanks in advance.

  Paranoid Android 13:10 24 Mar 2003

Sorry but you aren't making total sense, can you post the complete question ?

Marvin

  VoG™ 13:10 24 Mar 2003

Sorry, I don't understand the question!

Please can you type it out in full, then I'm sure one of us can help.

  VoG™ 13:11 24 Mar 2003

Snap!

  Paranoid Android 13:11 24 Mar 2003

PS is it the Excel instructions you need help with, or the Math ?

Marv.

  Paranoid Android 13:12 24 Mar 2003

Snap snap.

  barrie_g 13:35 24 Mar 2003

I have the total of a list of numbers in b8

I have a number in b2

I have to enter a formula in c2 to calculate the number in b2 as a percentage of the number in b8

sorry if this is as clear as mud but I no longer have the mock paper in my possession as its gone off to get marked:((

its just that the training place i'm at is overcrowded and understaffed and the tutors dont have a lot of time to explain things very clearly

  VoG™ 13:43 24 Mar 2003

=100*B2/B8

OR

=B2/B8 and format C2 as a percentage

  Paranoid Android 13:48 24 Mar 2003

Darn, VoG, too quick for me. I think you should know I'm feeling quite depressed.

Marvin.

  barrie_g 13:54 24 Mar 2003

thanks guys ticked as resolved

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Turn a photo into 16-bit pixel art

iMac Pro release date, UK price & specs

Football : comment regarder la Ligue 1 en direct ?