| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| order form | Excel Worksheet Functions | |||
| order form | Excel Discussion (Misc queries) | |||
| i want a order form | Excel Discussion (Misc queries) | |||
| Automated task to present data in a graph form. | Charts and Charting in Excel | |||
| Automated task to present data in a graph form. | Charts and Charting in Excel | |||
Linear Mode
