Re: Work like a little help with a very simple formual

Claus Busch

Guest

Posts: n/a

26th Apr 2012

Hi Jess,

Am Thu, 26 Apr 2012 09:33:21 -0500 schrieb Jess:

> one cell has a number 240, next cell has number 22.7, I want to
> multiply these numbers together and come out with 5.4, not 5448
>
> also one cell has a number 240, next cell has number 9.0, I want to
> multiply these numbers together and come out with 2.2 not 2160.

you're correct
Volt * Ampere = Watt (W)
Volt * Ampere/1000 = KiloWatt (kW)

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

« Opening Documents In Separate Windows? | convert text to values »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need a little help with a formual problem	Jesse	Microsoft Excel Discussion	2	19th Apr 2010 06:00 PM
some help with an IF formual or something like it	Lost Will	Microsoft Excel Worksheet Functions	4	19th Nov 2008 01:00 PM
printing Little Current month and Little Next month on Banner when it should little PRIOR month and little Next month.	jake_allen10@hotmail.com	Microsoft Outlook	0	3rd Nov 2006 08:30 PM
Blank screen with a box in upper left corner that has a little red square, a little green circle, and a little blue triangle	gdelcarlo	Windows XP Basics	1	5th May 2006 06:23 AM
RIS - very very very very very slow	=?Utf-8?B?TWF0dGhldyBFbGxpcw==?=	Windows XP Setup	3	6th Dec 2004 11:58 PM