| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Condition based on multiple cells
I would like to look at 3 cells: A6, C6, E6. If all 3 of these cells are
blank, I would like to return a blank cell. If any of the 3 cells has a value, I would like to return the average. I am familar with how to do this based on 1 cell, but confused as to how to get it to work with 3! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compulsory Cells based on Condition | Excel Discussion (Misc queries) | |||
| Sum Cells Based on Condition (2 problems) | Excel Worksheet Functions | |||
| How do I copy a set of cells based on a logical condition | Excel Discussion (Misc queries) | |||
| Adding cells based on condition | Excel Worksheet Functions | |||
| Counting Across Multiple Ranges, Based on Condition | Excel Worksheet Functions | |||
Threaded Mode
