#VALUE!

G

Guest

Hi, i am trying to create a simple spreadsheet to calculate the total amount
due to a employee.

I have a field with the total hours worked (TIME) and another field with the
hourly rate (CURRENCY). I am trying to multiply the two to get "TOTAL DUE
(CURRENCY).

I am using the =sum(.....) formula, but i get the #VALUE! error.

Can anyone help me.
 
G

Guest

Let's say you have

TIME in A1
CURRENCY in B1

If you want the amount to pay that employee, you need

=A1*B1

I'm guessing that one of your cells is not numeric. That's a reason you'd
get the #VALUE error.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if greater than? 1
Calculating payroll cost 1
Simple Time sheet, calculate OT 2
Time calculations for Scheduled vs Actual Employee Time and Wages 2
Time calculations for Scheduled Time vs. Actual Time Worked 1
Time calculations for Scheduled vs Actual Employee Time and Wages 4
Summary of Unique item values 2
currency and time calculation 1

Top