| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Evaluate a range of cells for true or false condition (Div/0)
I want to check a range of cells for an all zero condition to preclude a
divide by zero error. If any of the cells (in the range) contain non-zero data then proceed with the remaining calculation. If all the cells (in the range) are zeros, then stop and optionally present either a meaning full message (my composition) or just leave blank (""). =IF(logical_test,SUMIF(B1:B20,"E",A1:A20)/COUNTIF(B1:B20,"E"),"") -- Bill Billmire |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Percentage of True (or False) in a range | Excel Discussion (Misc queries) | |||
| What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
| Marking a range True or False based on a single Checkbox | Excel Programming | |||
| Hiding rows in a range based on TRUE/FALSE value in each row | Excel Discussion (Misc queries) | |||
| Formula: If 2 values (in a range of six) are >3 then TRUE, FALSE | Excel Discussion (Misc queries) | |||
Threaded Mode
