Results 1 to 10 of 10

Thread: M$ Excel masters..

  1. #1
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,682
    Thanks
    85
    Thanked
    15 times in 13 posts
    • XA04's system
      • Motherboard:
      • MSI X570-A Pro
      • CPU:
      • AMD Ryzen 5 3600
      • Memory:
      • Corsair 2x 8gb DDR 4 3200
      • Storage:
      • 1TB Serpent M.2 SSD & 4TB HDD
      • Graphics card(s):
      • Palit RTX 2060
      • PSU:
      • Antec Truepower 650W
      • Case:
      • Fractcal Meshify C
      • Operating System:
      • Windows 10
      • Monitor(s):
      • Asus 28" 4K
      • Internet:
      • Virgin 100mb Fibre

    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,682
    Thanks
    85
    Thanked
    15 times in 13 posts
    • XA04's system
      • Motherboard:
      • MSI X570-A Pro
      • CPU:
      • AMD Ryzen 5 3600
      • Memory:
      • Corsair 2x 8gb DDR 4 3200
      • Storage:
      • 1TB Serpent M.2 SSD & 4TB HDD
      • Graphics card(s):
      • Palit RTX 2060
      • PSU:
      • Antec Truepower 650W
      • Case:
      • Fractcal Meshify C
      • Operating System:
      • Windows 10
      • Monitor(s):
      • Asus 28" 4K
      • Internet:
      • Virgin 100mb Fibre
    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
    The late but legendary peterb - Onward and Upward peterb's Avatar
    Join Date
    Aug 2005
    Location
    Looking down & checking on swearing
    Posts
    19,380
    Thanks
    2,892
    Thanked
    3,403 times in 2,693 posts
    Format the cell to use currency as the number format...

  6. #6
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,682
    Thanks
    85
    Thanked
    15 times in 13 posts
    • XA04's system
      • Motherboard:
      • MSI X570-A Pro
      • CPU:
      • AMD Ryzen 5 3600
      • Memory:
      • Corsair 2x 8gb DDR 4 3200
      • Storage:
      • 1TB Serpent M.2 SSD & 4TB HDD
      • Graphics card(s):
      • Palit RTX 2060
      • PSU:
      • Antec Truepower 650W
      • Case:
      • Fractcal Meshify C
      • Operating System:
      • Windows 10
      • Monitor(s):
      • Asus 28" 4K
      • Internet:
      • Virgin 100mb Fibre
    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
  •