adding 2 variables gives wrong answer

[Bernieg]

Hi
I'm trying to get a simple sum to work, but the answer avades me
goodprod = 360 & optime = 625
goodprod / optime = 125

but the answer i get is 0.575999975204467

Cheers
Bernie





optime = Range("bm3").Value * 1440 'cell formatted to [m]
For r = 3 To lr
If Not IsEmpty(Cells(r, 6)) And Not IsEmpty(Cells(r, 7)) And IsEmpty(Cells(r, 66)) Or Cells(r, 66).Value <= 0 Then
Cells(r, 67).Value = empty
ElseIf Not IsEmpty(Cells(r, 6)) And Not IsEmpty(Cells(r, 7)) And Not IsEmpty(Cells(r, 66)) Then
Range("bo3").Value = (goodprod / optime)
End If
Exit For
Next

 

[doofusboy]

adding 2 variables gives wrong answer

Probably because you're not ADDING them, but DIVIDING them!

Range("bo3").Value = (goodprod / optime)

Try:

Range("bo3").Value = (goodprod + optime)

 

[Domski]

I'm very confused as to why you would expect 360 divided by 625 would come to 125???

Dom

 

[Jonmo1]

Agree with Dom..

I think you need to explain the logic behind your math.

This line

optime = Range("bm3").Value * 1440 'cell formatted to [m]

Indicates you're dealing with times, so math can get strange.
And formatting a cell to [m] does not change the actual underlying value, it only changes the way it is displayed.
625 Minutes is actually 0.434028...

 

[Bernieg]

Agree with Dom..

I think you need to explain the logic behind your math.

This line

optime = Range("bm3").Value * 1440 'cell formatted to [m]

Indicates you're dealing with times, so math can get strange.
And formatting a cell to [m] does not change the actual underlying value, it only changes the way it is displayed.
625 Minutes is actually 0.434028...

Hi guys

Yes the morning after the night before i'm afraid.
Is there a way to convert [m] formatted cell to general format.
i.e 0:45 in general is 0.03125, as i want a conversion to general giving a value of 45
Bernie

 

[Jonmo1]

looks like you were doing it with your code (*1440)

you could just put a formula in an adjescent column
=A1*1440
and format that cell as general