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) |