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.

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.

"Pinto1uk" wrote:

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.