#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. |
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. |
All times are GMT +1. The time now is 11:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com