# Excel KG

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

Not open for further replies.

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.

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. ### etafModerator

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

18.8496 x 15 = 282.744

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.

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

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. ### etafModerator

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

Joined:
Jan 17, 2011
Messages:
193
9. ### etafModerator

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. ### etafModerator

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

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

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

File size:
22 bytes
Views:
52
13. ### etafModerator

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

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

File size:
83.1 KB
Views:
51
15. ### etafModerator

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

As Seen On