View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
kassie kassie is offline
external usenet poster
 
Posts: 515
Default cant get the formula right

What does B5 and B6 contain?
Why do you say
e6 should say 3 as it was a better time than b5 - What is better
than b5?
e7 should say 1 as its not a better time than b6 - What is better
than b6?
e8 should say 2 as it is equal to b6 - What is equal to b6?
The same applies for E12 and E13

Surely, these arguments should be based on some cell(s) containing values
which are being compared to B4 and B6? You cannot have 1:33:20 in B5, 1:31:48
in E6, and then let E6 be equal to 3 at the same time. If you then have
1:34:10 in E7, then E7 vcannot be equal to 1 at the same time. The same with
1:33:20 in E8.

I suggest you repost, with more precise detail on your problem!


It is impossible to suggest a solution without sufficient information

--
Hth

Kassie Kasselman
Change xxx to hotmail


" wrote:

e5 could say 3 as its more than 0
e6 should say 3 as it was a better time than b5
e7 should say 1 as its not a better time than b6
e8 should say 2 as it is equal to b6



e12 should say 1 as its not a better time than b6
e13 should say 1 as its not a better time than b6