Home |
Search |
Today's Posts |
#1
|
|||
|
|||
multiplying a cell by a set number
i want to multiply a row of boxes(my hours) by a set number (my wage), then
have the product placed in a 3rd box. Then i want to be able to take that 3rd box and add it with another variable to go to another box. i basicly want to multiply my hours by my wage, then add my wage with my tips for a total. But i want to see all these numbers on the page individually. thanks in advance for the help. |
#2
|
|||
|
|||
Hi Gunny86, if you place your wage in a cell say A3 then enter the following in cell in B1 type the no of hours you worked then in B2 type =B1*$A$3 this will give you your total wage, you can then copy fill down the page as you go. to add you days tips to the total in A4 type the total amount of your tips then change your formula to =(b1*$A$3)+$A$4, this is a quick and dirty way to do it but it works. Regards, Jesse -- Jesse_Norris ------------------------------------------------------------------------ Jesse_Norris's Profile: http://www.excelforum.com/member.php...o&userid=25546 View this thread: http://www.excelforum.com/showthread...hreadid=464997 |
#3
|
|||
|
|||
you can also name the wages by using insert name define and used that name
for alll purposes "Jesse_Norris" wrote in message news:Jesse_Norris.1uz36e_1126069994.7406@excelforu m-nospam.com... Hi Gunny86, if you place your wage in a cell say A3 then enter the following in cell in B1 type the no of hours you worked then in B2 type =B1*$A$3 this will give you your total wage, you can then copy fill down the page as you go. to add you days tips to the total in A4 type the total amount of your tips then change your formula to =(b1*$A$3)+$A$4, this is a quick and dirty way to do it but it works. Regards, Jesse -- Jesse_Norris ------------------------------------------------------------------------ Jesse_Norris's Profile: http://www.excelforum.com/member.php...o&userid=25546 View this thread: http://www.excelforum.com/showthread...hreadid=464997 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
First Number in a Cell | Excel Worksheet Functions | |||
Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
number formatted cell | Excel Discussion (Misc queries) | |||
Maximum Number of Cell Formats | Excel Discussion (Misc queries) | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions |