Correction to Question on Ratios

's Computer Specifications

Fellow Excel Users:

How does one calulate ratios in Excel?

I want to calculate as follows:

If A>B then A:B=C eg. 2:1 = 2

BUT if A<B A:B=-C eg. 1:2 =-2.

Thanks, David
..

's Computer Specifications

Hi
see your post in Excel.worksheet.functions

--
Regards
Frank Kabel
Frankfurt, Germany

dalightfoot wrote:
> Fellow Excel Users:
>
> How does one calulate ratios in Excel?
>
> I want to calculate as follows:
>
> If A>B then A:B=C eg. 2:1 = 2
>
> BUT if A<B A:B=-C eg. 1:2 =-2.
>
> Thanks, David
> .

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMPRODUCT QUESTION?, Ratios	MrBill	Microsoft Excel Misc	3	4th May 2010 05:21 AM
correction to the question	=?Utf-8?B?TWlyIEtoYW4=?=	Microsoft Excel Programming	1	9th May 2006 02:56 AM
Spell Check Correction Case Correction Code Question	Dave Elliott	Microsoft Access Forms	1	17th Sep 2004 04:40 PM
Question correction	ANSWER	Microsoft Excel Setup	4	28th Apr 2004 08:01 PM
Question correction	ANSWER	Microsoft Excel Programming	1	28th Apr 2004 11:19 AM