| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiply a text box on a report times a dollar amount
I have a report that adds up the values of a number of fields. I want to
multiply the value in this text box time a dollar amount I am trying to do this throught the control source with no luck. Any ideas |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiply a text box on a report times a dollar amount
text box?If you link your text box to a cell by clicking in the text box and
type =(say)A2,you can reflect what ever A2 shows in your text box -- paul remove nospam for email addy! "gbpg" wrote: I have a report that adds up the values of a number of fields. I want to multiply the value in this text box time a dollar amount I am trying to do this throught the control source with no luck. Any ideas |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiply a text box on a report times a dollar amount
Hi
If the times are in Excel times e.g 7:00 for 7 hours, then you will need to multiply hours x 24 x rate. Excel stores its times as fractions of a day, hence the need to multiply by24. -- Regards Roger Govier "gbpg" wrote in message ... I have a report that adds up the values of a number of fields. I want to multiply the value in this text box time a dollar amount I am trying to do this throught the control source with no luck. Any ideas |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace last digit in a dollar amount | Excel Discussion (Misc queries) | |||
| multiply hours/minutes times dollars for total dollar amount | Excel Discussion (Misc queries) | |||
| Cenvert dollar amount into words | Excel Worksheet Functions | |||
| I need to find out how to multiply gross hours times amount of pay. | New Users to Excel | |||
| Hide row if dollar amount is zero | Excel Discussion (Misc queries) | |||
Linear Mode
