=(B2*E2)

must be entered in a cell other than B2 or E2. I suggest setting up new
columns for Job1 and Job2 cost and try your formula again.


"kynhart" wrote:


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