Results 1 to 10 of 10

Thread: M$ Excel masters..

  1. #1
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts

    M$ Excel masters..

    I'm using a simple formular to divide pence by a whole number, so something like: 0.36 divided by 24.
    (36p, divided by 24), this answer is 1.5p, but in excel it shows as 0.02.

    ........... WTF?.

    What have I done wrong?, it all works OK in pounds AND pence, just not pence alone

    Any help is greatly apreicated, thanks.

    Edit: tbh, i'm probably looking at it wrong, confusing the hell out of me now . I'll post once my mind has cleared up, please try help still though..

    Ok, in excel.. I think.. it should display 0.015, which should do, then I'll need to use some sort of if statement to make it display 15p.

    god, homework sucks, I can't see the dumb arses in my ICT class been able to do this, especially if i'm struggling
    Last edited by XA04; 11-09-2005 at 12:39 PM.

  2. #2
    Senior Member
    Join Date
    Oct 2003
    Posts
    2,069
    Thanks
    4
    Thanked
    7 times in 3 posts
    make sure its set to use enough decimal places when displaying number...select relevant cells and click button.
    button look something like:

    -> .00

    also 0.36 is in pound and you want the answer in pence...so change the formula to x100 on the end to convert it
    Twigman

  3. #3
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts
    Hi, thanks for the reply.

    The other calculations on the page are set out as, 4.50, 1.60 etc.

    I know the pence is set out as a pound, that's why I added the 0 and a decimal point after, so 0.36 is 36p.

    How do I.. "change the formula to x100 on the end to convert it"?

    Thanks

  4. #4
    Senior Member
    Join Date
    Aug 2005
    Location
    scotland
    Posts
    639
    Thanks
    5
    Thanked
    37 times in 34 posts
    select the cell in question and change it to

    =100*(your formula)

    To set teh number of decimal places right click the cell "format cell" "number" "currency" and set teh number of decimal places you want

  5. #5
    Admin team peterb's Avatar
    Join Date
    Aug 2005
    Location
    Southampton
    Posts
    19,321
    Thanks
    2,873
    Thanked
    3,376 times in 2,674 posts
    • peterb's system
      • Motherboard:
      • Nascom 2
      • CPU:
      • Z80B
      • Memory:
      • 48K 8 bit memory on separate card
      • Storage:
      • Audio cassette tape - home built 5.25" floppy drive
      • Graphics card(s):
      • text output (composite video)
      • PSU:
      • Home built
      • Case:
      • Home built
      • Operating System:
      • Nas-sys
      • Monitor(s):
      • 12" monocrome composite video input
      • Internet:
      • No networking capability on this machine
    Format the cell to use currency as the number format...

  6. #6
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts
    Sorry for the late reply.

    killie99, I tried that but it doesn't seem to actually be changing the number from 0.02 to 0.015? (then I think I can use the format cell > number > currency etc bit.

  7. #7
    Senior Member
    Join Date
    Aug 2005
    Location
    scotland
    Posts
    639
    Thanks
    5
    Thanked
    37 times in 34 posts
    you need to change the number of decimlal places you require: select the cell/cells you want to adjust, right click, "format cell" "number" "currency" and set the number of decimal places you require

  8. #8
    Senior Member
    Join Date
    Oct 2003
    Posts
    2,069
    Thanks
    4
    Thanked
    7 times in 3 posts
    well if you do change it to currency you will only get 2 decimal places, because there are 100p in a pound.
    Twigman

  9. #9
    Senior Member
    Join Date
    Aug 2005
    Location
    scotland
    Posts
    639
    Thanks
    5
    Thanked
    37 times in 34 posts
    incorrect, you can have more than 2 decimal places when using currency.

  10. #10
    Senior Member
    Join Date
    Oct 2003
    Posts
    2,069
    Thanks
    4
    Thanked
    7 times in 3 posts
    you *can*, but not as default when you select the option.
    Twigman

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 12-08-2005, 08:50 AM
  2. Excel cells
    By joshwa in forum Software
    Replies: 4
    Last Post: 08-02-2005, 04:18 PM
  3. Rounding to thousands in Excel?
    By johnnr892 in forum Software
    Replies: 1
    Last Post: 15-01-2005, 01:43 AM
  4. Excel spreadsheet fixing tool?
    By joshwa in forum Software
    Replies: 2
    Last Post: 28-10-2004, 11:23 AM
  5. Excel Form Label Errors
    By Tomahawk in forum Software
    Replies: 4
    Last Post: 08-04-2004, 03:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •