Simple(?) calculation question

[Angyl]

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]

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

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

 

[Angyl]

EXCELLENT, THAT WORKED! Thanks, Spyd3r

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

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