View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Raffael Raffael is offline
external usenet poster
 
Posts: 29
Default Calculations don't compute...

Well, it shouldn't... :)

1/10 is different from 91/100, right? The difference between them is the
same (9), and so is the percentage...

Regards!

"Steven Sinclair" escreveu na
mensagem ...
Here's what I have...

A1 B1 C1
16.16 =((c1-a1)/2)+a1 24.44

Which, of course, gives us the value of 20.3 in cell B1, which is the
mid-point between the values in cells A1 and C1. However, why do I get
different percentages when I calculate a1/b1 and b1/c1? Shouldn't the
percentage be the same if the difference between the numbers is the same?

Thanx.