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.
|