Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Division problem
I am trying to make a simple sheet to track my performance at work. We get
bonuses based on productivity and I entered the equation =b/c*d and if there is no data in those boxes, I get the #DIV/0! error. These cells will stay empty until each work day is over. Sometimes, a row will stay empty because I have not run a machine to put data there. How do I avoid the #DIV/0! error when cells/rows are empty of data or have a zero value? I have three rows per work day and some days I run one machine, some days I run two and every now and then, I run three. I need to be able to leave rows blank and still get numbers instead of that error. I have not finished putting in the equations and would appreciate some help resolving this. Parts Run Hourly Rate Labor % Hours Earned Total Monday 192 31 0.5 =B2/C2*D2 92 12 0.65 =B3/C3*D3 0 0 0.6 =B4/C4*D4 =SUM(E2:E4) Tuesday =SUM(E5:E7) Wednesday =SUM(E8:E10) Thursday =SUM(E11:E13) Friday =SUM(E14:E16) Weekly Earned Hours =SUM(F4:F16) Wondering |
#2
|
|||
|
|||
192 31 0.5 3.097
92 12 0.65 4.983 #DIV/0! #DIV/0! 0.000 0.000 0.000 0.000 #DIV/0! Maybe this will show it better. |
#3
|
|||
|
|||
Hi
Put this formula in a cell =IF(ISERROR(B1:D1),"",B1/C1*D1) You will have to Ctrl + Shift+ Enter to make it an array formula Copy down as many lines as needed HTH Michael "Wondering" wrote: 192 31 0.5 3.097 92 12 0.65 4.983 #DIV/0! #DIV/0! 0.000 0.000 0.000 0.000 #DIV/0! Maybe this will show it better. |
#5
|
|||
|
|||
My thanks to both of you. I tried both suggestions and they both work. I
apprecaite the help. Wondering |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Problem | New Users to Excel | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Baffling formula problem | Excel Discussion (Misc queries) | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
label problem | Excel Worksheet Functions |