Is it possible to convert kilos to pounds using Excel *2010*?

[HizExceLenCy]

The pilot (using a flight simulator,) is programming the "Flight Management Computer" or FMC, and calculating how much fuel he needs, he said to round up to the nearest 100 kilos, then add a 100 kilos. So I'd like to know how to convert those two units.

Thanks in advance,

HizExceLenCy

 

[WaterGypsy]

multiply by 2.2 ?

 

[mikerickson]

A formula like =CONVERT(A1,"kg","lbm") would do that.

So, given pounds in A1, to return the "round up to 100 kg and add 100kg" try =CEILING(CONVERT(A1,"lbm","kg"), 100) + 100


I must admit to a bit of confusion. The title says kilograms to pounds, but the question sounds like you are doing pounds to kg.

 

[HizExceLenCy]

Many thanks for the reply; and many apologies for the point of confusion.

He's a pilot with with a British accent, and so he's using the metric system. Which is a foreign system to me, especially when he's talking about a 100 kilos. So, I thought I'd let Excel do the work for me.

I'm sorry that the initial message wasn't clearer.

I was wondering, now that you mention it, could you give me both conversions?

Thanks in advance,

HizExeLenCy

 

[mikerickson]

Excel Help has a full explanation of how to use the CONVERT function.

The round-up part is all done with the CEILING function.

 

[HizExceLenCy]

Thanks