1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel KG

Discussion in 'Business Applications' started by getthecansout, Jan 2, 2013.

Thread Status:
Not open for further replies.
Advertisement
  1. getthecansout

    getthecansout Thread Starter

    Joined:
    Jan 17, 2011
    Messages:
    193
    Hello,

    Is there an add-on for excel to format weights in Excel.
    What im trying to do in excel is instead of it saying 282.744 i want to change it to kilos.
    I know you can format cell to a few things like currency and decimal places etc.
    I was hoping i can format cell to automatically change to kilos.
     
  2. getthecansout

    getthecansout Thread Starter

    Joined:
    Jan 17, 2011
    Messages:
    193
    I can get it to print kg by format/format cell/custom
    click on type and enter 00 "Kg" i got that far.
    In cell D6 i typed:-

    =SUM(B6*3.1416)*C6

    and the answer was 282.74 Kg

    i know it should read about 500g or .5 kg not 282.74 Kg

    B6=6 C6=15

    My minds blank any help would be grateful
     
  3. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,252
    First Name:
    Wayne
    6 x 3.1416 = 18.8496

    18.8496 x 15 = 282.744
     
  4. getthecansout

    getthecansout Thread Starter

    Joined:
    Jan 17, 2011
    Messages:
    193
    What i want to do is make the answer = 500g
    I got that answer 282.74 kg but i only need 500 grams of sugarpaste and not 282.74 kg as thats way too much.
     
  5. getthecansout

    getthecansout Thread Starter

    Joined:
    Jan 17, 2011
    Messages:
    193
    How do i alter

    =SUM(B6*3.1416)*C6

    to give me the answer 500 g and not 282.74 kg
     
  6. getthecansout

    getthecansout Thread Starter

    Joined:
    Jan 17, 2011
    Messages:
    193
    This is what the weights should be:-
    Size in InchesWeight for a Round CakeWeight for a Square Cake6"500g750g7"750g875g8"875g1kg9"1kg1.25kg10"1.25kg1.5kg11"1.5kg1.75kg12"1.75kg2.2kg
     
  7. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,252
    First Name:
    Wayne
    thats a little difficult to answer

    B6 and C6 what do they represent
    and whats the 3.1416


    to get 0.5 kg
    then divide by 565.48

    but its a difficult question to answer
     
  8. getthecansout

    getthecansout Thread Starter

    Joined:
    Jan 17, 2011
    Messages:
    193
  9. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,252
    First Name:
    Wayne
    can we see a sample spreadsheet - you may be able to use a lookup to work out the sugar paste based on the size
     
  10. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,252
    First Name:
    Wayne
    so if you crete that table in a spreadsheet and the you can use two cells

    one if round or square and one for the size

    and then use an IF with a vlookup

    something like

    =IF( cell = round , vlookup(cell for diameter , range of the table , 2, false) , vlookup(cell for diameter , range of the table , 3, false) )
     
  11. getthecansout

    getthecansout Thread Starter

    Joined:
    Jan 17, 2011
    Messages:
    193
    its on the ready reckoner sheet
     
  12. getthecansout

    getthecansout Thread Starter

    Joined:
    Jan 17, 2011
    Messages:
    193
    Sorry file was over 300 so had to zip it.
     

    Attached Files:

  13. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,252
    First Name:
    Wayne
    zip file empty
     
  14. getthecansout

    getthecansout Thread Starter

    Joined:
    Jan 17, 2011
    Messages:
    193
    Sorry hows this one
     

    Attached Files:

  15. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,252
    First Name:
    Wayne
    the calculator on the web site is using a square inch method for calculating the icing

    so not sure how you work out the square inch value on a round cake and how deep/high the cake is

    if a 6" square cake - then thats 6x6
    so a 6" square is 750g
    http://www.sweetsuccess.uk.com/cakeculatorpaste.asp?#

    at 15g per inch than 750/15 = 50
    not sure how a 6" square cake makes 50
    6x6 = 36 - for the top
    which leaves 14 to make upto the 50 - for the sides

    cant work it out
    but it should just be 15 * whatever the square inches are for the type and size of the cake
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1083385

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice