# excel result return wrong calcuation result

1. ## excel result return wrong calcuation result

The cell K2 = sum( I2*AS2)
in which
I2= 20871 where the forumla here is I2=SUM(G2+H2)
AS2 =0.077 - where the forumla here is
So, the correct result should be K2= 1607.067.
Why it calculates to the cell of K2 result return now is
1598.588 - it is wrong answer.

For details, pls see the wrapwrepusage.zip file

It is a big different.
Pls instruct !
thanks
gary
mY EMAIL: [email protected]

+-------------------------------------------------------------------+
|Filename: wrapwrepusage.zip |
+-------------------------------------------------------------------+

--
garyww

2. ## RE: excel result return wrong calcuation result

why sum(I2*AS2)? why not just I2*AS2
sum(H2+G2) should be =h2+g2 or sum(H2,G2)
your 0.77 is actually 0.076593743 thats why you get 1598.588

--
paul
[email protected]

"garyww" wrote:

>
> The cell K2 = sum( I2*AS2)
> in which
> I2= 20871 where the forumla here is I2=SUM(G2+H2)
> AS2 =0.077 - where the forumla here is
> So, the correct result should be K2= 1607.067.
> Why it calculates to the cell of K2 result return now is
> 1598.588 - it is wrong answer.
>
> For details, pls see the wrapwrepusage.zip file
>
>
> It is a big different.
> Pls instruct !
> thanks
> gary
> mY EMAIL: [email protected]
>
>
> +-------------------------------------------------------------------+
> |Filename: wrapwrepusage.zip |
> +-------------------------------------------------------------------+
>
>
>
> --
> garyww
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1