Jump to content

Report Formulas


Recommended Posts

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

Link to comment

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...