| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
don't show #DIV/0 error in cell
I'm using the following formula, which is GREAT, but I would like to alter it
to when Col F & Col C are 0 there is not #DIV/0 shown in the cell. =SUMIF(F13:F51,"IN",C13:C5)/COUNTIF(F13:F51,"IN") Same thing for the formula =IF(M3=0,"",+M3/K7*100) or =INT(K1) Again, GREAT formulas, but when M3 and K7 are both 0, I'd like no error message in cell as well as when K1 is 0 This is probably a very easy fix, I just can't get it right. Thanks in advance. Christy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error message - PivotTable will not fit on sheet. Show as much as | Excel Worksheet Functions | |||
| Pivot Table Show Top 10 Error | Excel Discussion (Misc queries) | |||
| format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
| Formatting to show/not show "DUE" and "RECEIVED" in cell | New Users to Excel | |||
| enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
Threaded Mode
