Excel calculate ratios

  • Thread starter Thread starter dalightfoot
  • Start date Start date
D

dalightfoot

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 =1

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

Thanks, David
 
Back
Top