Calculate a ratio of two numbers to the total

's Computer Specifications

--
Richard

's Computer Specifications

With numbers in A1 and A2 use:
=A1/(A1+A2)
and
=A2/(A1+A2)
and
=A1/A2
--
Gary''s Student - gsnu200794

"rhh29" wrote:

>
> --
> Richard

's Computer Specifications

Thank you. It seems easy once one know the formula
--
Richard

"Gary''s Student" wrote:

> With numbers in A1 and A2 use:
> =A1/(A1+A2)
> and
> =A2/(A1+A2)
> and
> =A1/A2
> --
> Gary''s Student - gsnu200794
>
>
> "rhh29" wrote:
>
> >
> > --
> > Richard

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate a close ratio	tin95	Microsoft Excel Misc	2	25th Jan 2008 08:12 PM
how do I calculate the total of the lowest 10 numbers in an array	=?Utf-8?B?TGVyb3kgNjk0?=	Microsoft Excel Misc	7	9th Jul 2007 02:54 PM
Macro that counts the Nbr of Teams and calculate the total & Ratio	=?Utf-8?B?SnVyYXNzaWVu?=	Microsoft Excel Misc	0	6th Mar 2007 05:20 PM
calculate aspect ratio	neverstill	Microsoft C# .NET	7	17th Dec 2003 09:11 AM
Ratio to total		Microsoft Access Queries	1	21st Oct 2003 04:41 PM