div error

Hi everyone, Trying to get the average processing time of coloumn K but I get a #DIV/0! error. Does anyone know what could be wrong? Both coloumns are formatted as TIME values but K is still text when using =ISTEXT. Formula =AVERAGE(K2:K10) I get a #VALUE! error when using this formula...

I'm having a couple issues with formulas which i'm not smart enough to solve, I hope someone will be able to help me, I've added the minisheet at the end of this wall of text K to N is filled manually. Error: Q displays error "VALUE" if K or M is N/A, Q should remain blank in this case...

Hello, I have cells C5:C36 that contain a series of IF formulas (=IF(B5="L4(+)","95%",IF(B5="L4","85%",IF(B5="L4(-)","80%",IF(B5="L3(+)","79%",IF(B5="L3","75%",IF(B5="L3(-)","70%",IF(B5="L2(+)","69%",IF(B5="L2","65%",IF(B5="L2(-)","60%",))))))))) that reference the adjacent cells B5:B36. When I...

Hello! I'm very new to Excel. I have a spreadsheet where oftentimes my denominator is 0 (it's frustrating, but that's how my work wants it done). Basically, if the number is 0/0 I want it to come up as "-". If the number is (>0)/0, I want it to return 100%. I know that the error is...

I am using excel 2007. I need to average numbers in a column within a date range. The column contains numbers and blank cells. The formula works but it return a DIV/0 error. I know i have a dividing by o problem but I am unsure where and how to edit my formula. This is my formula...

I am getting this pesky DIV error. Columns are Price:Order: Free Goods : Total: Net Easy One $8.00: Order 2: No Free Goods: $16.00: $16.00 A little harder: $8.00: Order 2: No Free Goods: $8.00: $8.00 $6.00: Order 0: 2 Free Goods: $0.00: $8.00 - 12.00 in free goods keep getting div error...