# Excel KG

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### getthecansout

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.

#### getthecansout

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

#### etaf

Wayne
Moderator
6 x 3.1416 = 18.8496

18.8496 x 15 = 282.744

#### getthecansout

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.

#### getthecansout

How do i alter

=SUM(B6*3.1416)*C6

to give me the answer 500 g and not 282.74 kg

#### getthecansout

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

#### etaf

Wayne
Moderator
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

#### etaf

Wayne
Moderator
can we see a sample spreadsheet - you may be able to use a lookup to work out the sugar paste based on the size

#### etaf

Wayne
Moderator
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) )

#### getthecansout

its on the ready reckoner sheet

#### getthecansout

Sorry file was over 300 so had to zip it.

#### Attachments

• 22 bytes Views: 52

Wayne
Moderator
zip file empty

#### getthecansout

Sorry hows this one

#### Attachments

• 83.1 KB Views: 51

#### etaf

Wayne
Moderator
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
We've allowed 15g each of sugarpaste and marzipan per square inch of cake. Using the quantities suggested should cover the cake to a depth of approx 5mm - the exact weight you use will depend on how thinly you roll the paste!
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

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On