Thread: #VALUE!
View Single Post
  #1   Report Post  
Pinto1uk
 
Posts: n/a
Default #VALUE!

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.