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

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.
 

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
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,456
6 x 3.1416 = 18.8496

18.8496 x 15 = 282.744
 

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.
 

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
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,456
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
Joined
Oct 2, 2003
Messages
65,456
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
Joined
Oct 2, 2003
Messages
65,456
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) )
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,456
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.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Staff online

Top