Question About formulas

[quietkagome]

Hello everyone, I need some big help on functions and formulas as I am completely stumped, and am going to get some tutoring to further my knowledge of excel, on account of me entering several different formulas, and not one being accurate. I have to create a formula in cell c5 that calculates the monthly insurance premiums for an entire accounting department. The monthly premium is 42.68 in cell B14 and the total number of employees in the accounting department is 58, located in cell B10. I also have to use in the formula an absolute reference. Does anyone have any ideas on this? Please explain. Thank you very much for reading my post.

 

[quietkagome]

*UPDATE* I did research my formulas and I actually made the correct formula, but I appreciate this forum. I definitely will be here again if I have questions.

 

[C with no eyes]

Put $ before a column reference and/or row reference so that it won't change when dragged.

e.g. if you put =B2 then dragged down the next formula would be =B3 then =B4 etc.
Similarly if you put =B2 the dragged right the next formula would be =C2 then =D2 etc.

If you type =$B$2 then drag in any direction, it will not stop the formula from containing cell B2

Put a $ in front of just a column and drag it both ways. What happens? Play around.

 

[FDibbins]

...I also have to use in the formula an absolute reference. Does anyone have any ideas on this? Please explain...

This sounds like a homework assignment?