Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula help pls
Hi. Guys
I need some help with the following. I've got a list of employees in column A, their ID no. in B and the various [different] rates per hour in column C. Depending on the type of work/day their remuneration is calulated at either 1; 1½ or 2 times the hourly rate. I've managed to get the formula to do the calculation for employee 1 in row 12 - this is my code: ActiveCell.Formula = "=round((" & Range("C12").Address(False, True) _ & "*" & ActiveCell.Offset(0, -1).Address(False, False) & "),2)" Currently I copy this formula and paste it in the next rows for the other employees. I've tied my best to get the formula to refer to the specific employee's row no in column C without any luck. Bottom line - no matter in which column I do the calculation, the rate remains in column C Thanks in advance ! -- HJN |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula help pls
I think you are going to have to give us some more information. Your last
sentence is the one that puzzles me most... "Bottom line - no matter in which column I do the calculation, the rate remains in column C" Why do you think the formula you posted, when placed in other columns, will change Column C's value? Exactly what are you attempting to accomplish with your code? -- Rick (MVP - Excel) "Hennie Neuhoff" wrote in message ... Hi. Guys I need some help with the following. I've got a list of employees in column A, their ID no. in B and the various [different] rates per hour in column C. Depending on the type of work/day their remuneration is calulated at either 1; 1½ or 2 times the hourly rate. I've managed to get the formula to do the calculation for employee 1 in row 12 - this is my code: ActiveCell.Formula = "=round((" & Range("C12").Address(False, True) _ & "*" & ActiveCell.Offset(0, -1).Address(False, False) & "),2)" Currently I copy this formula and paste it in the next rows for the other employees. I've tied my best to get the formula to refer to the specific employee's row no in column C without any luck. Bottom line - no matter in which column I do the calculation, the rate remains in column C Thanks in advance ! -- HJN |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula help pls
Try this:
ActiveCell.Formula = "=round((" & Range("C12").Address(True,False) _ & "*" & ActiveCell.Offset(0, -1).Address(False, False) & "),2)" "Hennie Neuhoff" wrote in message ... Hi. Guys I need some help with the following. I've got a list of employees in column A, their ID no. in B and the various [different] rates per hour in column C. Depending on the type of work/day their remuneration is calulated at either 1; 1½ or 2 times the hourly rate. I've managed to get the formula to do the calculation for employee 1 in row 12 - this is my code: ActiveCell.Formula = "=round((" & Range("C12").Address(False, True) _ & "*" & ActiveCell.Offset(0, -1).Address(False, False) & "),2)" Currently I copy this formula and paste it in the next rows for the other employees. I've tied my best to get the formula to refer to the specific employee's row no in column C without any luck. Bottom line - no matter in which column I do the calculation, the rate remains in column C Thanks in advance ! -- HJN |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |