Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I have a spreadsheet that I do job costing on and have been using a calculator to figure out my job costing. Let me give you a sample A B C D E F 1Hours Rate Total JOB1 JOB 2 2 40 $10 $400 20 20 3 4 5 I NEED TO FIND A FORMULA TO TURN THE 20 HOURS INTO dOLLARS. SOMETIMES 1 PERSON WILL WORK ON 4 OR FIVE DIFFERENT JOBS AND i NEED A MONETARY VALUE WHERE THE HOURS ARE, SO I HAVE BEEN DOING IT MANUALLY I TRIED DOING B2*E2 AND IT SAYS I HAVE A CIRCULAR SOMETHING, THAN I TRIED =(B2*E2) i NEED FOR THE HOURS TO TIMES THE RATE TO GIVE ME A DOLLAR AMOUNT ON d2 AND E2......wHAT AM I DOING WRONG........PLEASE I AM READY TO SCREAMMMM MMMMMM -- kynhart |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make LOOKUP give zero if it can't find the lookup_value? | Links and Linking in Excel | |||
Give multiple charts on a worksheet/workbook same header or footer | Excel Discussion (Misc queries) | |||
Give multiple charts on a worksheet/workbook same header or footer | Charts and Charting in Excel | |||
I would like to use function to give car allowance for grade D on. | Excel Discussion (Misc queries) | |||
How do I give a hyperlink of TOC of Word in Excel | Excel Discussion (Misc queries) |