Prev: Changing initials into numbers
Next: Sumproduct Search, Sum Durations
From: T. Valko on 3 Feb 2010 16:17
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Carolan" <Carolan(a)discussions.microsoft.com> wrote in message
news:E1D6624E-8D53-4D59-8672-9165B9E7F88D(a)microsoft.com...
> Thank you. This one worked the best.
>
> "T. Valko" wrote:
>
>> Use rounding on the multiplier formula:
>>
>> =ROUND(A1*0.001665,2)
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Carolan" <Carolan(a)discussions.microsoft.com> wrote in message
>> news:80F8A026-2725-4A94-9E15-4B89368BB6C3(a)microsoft.com...
>> >I have a column of figures which is the result of multiplied column A x
>> > Column B. Column B is a multiplier of .001665. The result is shown to
>> > two
>> > decimal places. When I total the results in Column B, using formula
>> > =SUM(B1:B2), it gives the result as 11.16 instead of 11.15. Can I fix
>> > this
>> > somehow so it gives the correct total?
>> >
>> > Example
>> > A Formula in B Result in B
>> > 3250.00 =A1x0.001665 5.41
>> > 3450.00 =A2x0.001665 5.74
>> > Total 11.16
>> >
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: Changing initials into numbers
Next: Sumproduct Search, Sum Durations