LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
kynhart
 
Posts: n/a
Default Help I Am Ready To Give Up


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make LOOKUP give zero if it can't find the lookup_value? Dmitry Kopnichev Links and Linking in Excel 3 October 12th 05 09:47 PM
Give multiple charts on a worksheet/workbook same header or footer Ches Excel Discussion (Misc queries) 8 July 4th 05 09:29 PM
Give multiple charts on a worksheet/workbook same header or footer Ches Charts and Charting in Excel 2 July 4th 05 04:58 PM
I would like to use function to give car allowance for grade D on. Masoom Al-Omran Excel Discussion (Misc queries) 1 May 23rd 05 08:40 PM
How do I give a hyperlink of TOC of Word in Excel Hatti Excel Discussion (Misc queries) 1 April 6th 05 06:11 PM


All times are GMT +1. The time now is 10:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"