Percentage help in automated order form
 

I need percentage help please with an automated order form.
I am a somewhat newbie to excel and have 2003.

In H25 I have a $ amount.
I want to be able to put any percentage (as a discount) in I25
and have the - the percentage show up in J25.

Percentage help in automated order form
 

what do you mean by...have the - the percentage show up in J25.

"scrapjaci" wrote in message
...
I need percentage help please with an automated order form.
I am a somewhat newbie to excel and have 2003.

In H25 I have a $ amount.
I want to be able to put any percentage (as a discount) in I25
and have the - the percentage show up in J25.

Percentage help in automated order form
 

=H25*(1-I25)
--
David Biddulph

"scrapjaci" wrote in message
...
I need percentage help please with an automated order form.
I am a somewhat newbie to excel and have 2003.

In H25 I have a $ amount.
I want to be able to put any percentage (as a discount) in I25
and have the - the percentage show up in J25.

Percentage help in automated order form
 

Put my $ amount in H25. Put a minus % amount in I25 and have the discounted
new $ amount show up in J25. ($100.00 - 50% = $50.00)
--
Thanks for all the help!
Jaci


"Gaurav" wrote:

what do you mean by...have the - the percentage show up in J25.

"scrapjaci" wrote in message
...
I need percentage help please with an automated order form.
I am a somewhat newbie to excel and have 2003.

In H25 I have a $ amount.
I want to be able to put any percentage (as a discount) in I25
and have the - the percentage show up in J25.

Percentage help in automated order form
 

Thank you so much!!! I tried everything and could not get it to work.
--
Thanks for all the help!
Jaci


"David Biddulph" wrote:

=H25*(1-I25)
--
David Biddulph

"scrapjaci" wrote in message
...
I need percentage help please with an automated order form.
I am a somewhat newbie to excel and have 2003.

In H25 I have a $ amount.
I want to be able to put any percentage (as a discount) in I25
and have the - the percentage show up in J25.