Simple(?) calculation question

I have a EXCEL spreadsheet from one of our clients that I need to convert to
a form in Word, but I'm having trouble converting one of their calcluations.

In Excel the formula is =O95*(1-P95)

That's it. Cell O95 contains a dollar amount ($672)
and cell P95 contains a percentage (7.8%)

The answer in Excel is $620

No matter how I set this calcuation up in Word in the form field, I can't
get the same answer...not even close.
The field with the original number ($672) is named ModifiedPremium and I've
tried

=(ModifiedPremium)*7.8
=(ModifiedPremium)*(1-7.8)
=(ModifiedPremium)*(1-(7.8))

Etc...

Anyone know how this calculation SHOULD look? Thanks.

spyd3r
Thu Sep 07 13:45:02 CDT 2006

Although the percentage is displayed as 7.8% in Excel, it is actually stored
as 0.078...

Try:
=(ModifiedPremium)*(1-(7.8/100))

"Angyl" wrote:

> I have a EXCEL spreadsheet from one of our clients that I need to convert to
> a form in Word, but I'm having trouble converting one of their calcluations.
>
> In Excel the formula is =O95*(1-P95)
>
> That's it. Cell O95 contains a dollar amount ($672)
> and cell P95 contains a percentage (7.8%)
>
> The answer in Excel is $620
>
> No matter how I set this calcuation up in Word in the form field, I can't
> get the same answer...not even close.
> The field with the original number ($672) is named ModifiedPremium and I've
> tried
>
> =(ModifiedPremium)*7.8
> =(ModifiedPremium)*(1-7.8)
> =(ModifiedPremium)*(1-(7.8))
>
> Etc...
>
> Anyone know how this calculation SHOULD look? Thanks.
>

Angyl
Thu Sep 07 16:42:01 CDT 2006

EXCELLENT, THAT WORKED! Thanks, Spyd3r

"spyd3r" wrote:

> Although the percentage is displayed as 7.8% in Excel, it is actually stored
> as 0.078...
>
> Try:
> =(ModifiedPremium)*(1-(7.8/100))
>
> "Angyl" wrote:
>
> > I have a EXCEL spreadsheet from one of our clients that I need to convert to
> > a form in Word, but I'm having trouble converting one of their calcluations.
> >
> > In Excel the formula is =O95*(1-P95)
> >
> > That's it. Cell O95 contains a dollar amount ($672)
> > and cell P95 contains a percentage (7.8%)
> >
> > The answer in Excel is $620
> >
> > No matter how I set this calcuation up in Word in the form field, I can't
> > get the same answer...not even close.
> > The field with the original number ($672) is named ModifiedPremium and I've
> > tried
> >
> > =(ModifiedPremium)*7.8
> > =(ModifiedPremium)*(1-7.8)
> > =(ModifiedPremium)*(1-(7.8))
> >
> > Etc...
> >
> > Anyone know how this calculation SHOULD look? Thanks.
> >