i need help with a calculation formula...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

if E1:E12 (each) cell is equal to more than 9.5, I need L12 to equal the
cells minus 9.5 - i'm trying to get my worksheet to calculate overtime hours
for our employees

for example E1 is 10.5, E2 is 9.5 , E3 is 10...I need L12 to show 1.5 in
overtime hours. I'm not sure is excel can calculate this way, but if it can
I would surely appreciate any input!
 
Enter this in L12 (this is an array formula so enter with Ctrl+Shift+Enter):

=IF(COUNTIF(E1:E3,">"&9.5)>0,SUM(E1:E3-9.5),"")
 

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

breakpoint calculation 4
I have a complex formula where I need to build in a MAX function 4
Trying to calculate hours worked on timecard using "IF" command 6
Payroll calculations for real time 2
Please help with SUM formula dependent on results of other cells 2
How do I separate and calculate a value in a cell with an IF 2
Overtime Calculation 1
Formula for advance worksheet name to next worksheet name 2

Back
Top