Help with Formula

[Andy]

Hello,

I have just started learning Excel
The problem I am having is using percentages in my formulas.
what I am trying to do is this $69.00 * 4 - 5%.
now that should equal $262.20

The Hire prices are on a separate sheet called "Vehicles".
Vehicles!E32 represents the daily hire cost of a car "$69.00"
H5 represents days rental "4"
the 5% represents a 5% discount

My formula is =H5*Vehicles!E32-5%
the result I keep getting is $275.95

I don't know what im doing wrong?
Any help would be appreciated.

Cheers, Andy

 

[David McRitchie]

Hi Andy,
=.95 * 4 * 69.00
you are subtracting 5 cents in your formula
= 4*69 - .05

 

[Gord Dibben]

Andy

Try =(H5*Vehicles!E32)*.95

Returns 262.20 for me.

Gord Dibben Excel MVP

 

[Guest]

formula I would recommend is
SUM((69*4)-(69*4)*0.05)
...s

 

[AÑÐ¥]

Thank you all for your help

Cheers, Andy

In Andy bent over and squelched this bit of shit out:
:: Hello,
::
:: I have just started learning Excel
:: The problem I am having is using percentages in my formulas.
:: what I am trying to do is this $69.00 * 4 - 5%.
:: now that should equal $262.20
::
:: The Hire prices are on a separate sheet called "Vehicles".
:: Vehicles!E32 represents the daily hire cost of a car "$69.00"
:: H5 represents days rental "4"
:: the 5% represents a 5% discount
::
:: My formula is =H5*Vehicles!E32-5%
:: the result I keep getting is $275.95
::
:: I don't know what im doing wrong?
:: Any help would be appreciated.
::
:: Cheers, Andy

 

[AÑÐ¥]

Cheers Gord,
That did the trick

Andy

In Gord Dibben bent over and squelched this out:
:: Andy
::
:: Try =(H5*Vehicles!E32)*.95
::
:: Returns 262.20 for me.
::
:: Gord Dibben Excel MVP
::
:: On 27 Mar 2004 16:32:07 -0800, (e-mail address removed) (Andy)
:: wrote:
::
::: Hello,
:::
::: I have just started learning Excel
::: The problem I am having is using percentages in my formulas.
::: what I am trying to do is this $69.00 * 4 - 5%.
::: now that should equal $262.20
:::
::: The Hire prices are on a separate sheet called "Vehicles".
::: Vehicles!E32 represents the daily hire cost of a car "$69.00"
::: H5 represents days rental "4"
::: the 5% represents a 5% discount
:::
::: My formula is =H5*Vehicles!E32-5%
::: the result I keep getting is $275.95
:::
::: I don't know what im doing wrong?
::: Any help would be appreciated.
:::
::: Cheers, Andy