StaticDOS Posted April 6, 2010 Share Posted April 6, 2010 Howdy gents im working on a wall report at the moment and im just wondering what the formula for labour would be if lets say I wanted to put it at ?10 per square ft? Quote Link to comment
Pat Stanford Posted April 6, 2010 Share Posted April 6, 2010 In the header row put in two extra columns. In one enter the labor rate (10, make sure you don't include the currency symbol as it will make it text instead of a number. If the are is in column A and the rate is in column B and the database starts in row 2 then the formula for column C would be: =A2*B2 to give you the area times the rate. If you don't want to have the rate display in every row, you could also put the rate in a cell outside of the database and use an absolute reference. If the area is in column A and the labor rate is inc cell C4 the formula would be: =A2*$C$4 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.