one last question( maybe simple)

[Spockster]

I have =vlookup(a1,the range,2,0) how can i add in the *86400 there. I can't seem to get it to work.

 

[Bugs]

try this

=VLOOKUP(A1,TheRange,2,0)*886400

 

[Spockster]

already tried that and it didn't work. Thanks though... any other ideas

 

[Bugs]

it works for me are you getting a result at all (Without) the *86400

 

[Chris Davison]

are you trying to bring back a "time/date" answer ?

hh:mm:ss ?

60 x 60 x 24 is 86,400......

 

[Spockster]

when I do my vlookup and add the *86400 i get a #value error. And not sure why?

 

[Ivan F Moala]

On 2002-09-07 12:28, Spockster wrote:
when I do my vlookup and add the *86400 i get a #value error. And not sure why?

What do you get without *86400

 

[Spockster]

I get the Vlookup answer I was looking for which is 15:10 and another vlookup finds 00:55 I need to divid :55/15:10 to find the percentage.

 

[Spockster]

I have formatted the cells to h:mm:ss and still nothing the first Vlookup is

vlookup(a1,range,2,0) which gives hours in this format 15:10

Second vlookup is

vlookup(a1,range,2,0) which gives hours in this format 0:55

I need to divide 0:55/15:10 to find the percentage and that is what is giving me the #value! error

Need Help

 

[Dave Patton]

I am not sure if I follow your question or I do not see your problem.

=VLOOKUP(A3,F2:G4,2,0)/VLOOKUP(A2,F2:G4,2,0)

Format as percentage should give the same result as dividing the numbers manually or
separately.

If you want a percentage, format as Percentage.