|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 20th, 2009, 03:13 PM
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! 
|
|
#2
November 20th, 2009, 03:20 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Condition based on multiple cells
=IF(AND(A6="",C6="",E6=""),"",AVERAGE(A6,C6,E6))
WAR wrote: 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!
|
|
#3
November 20th, 2009, 03:21 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Condition based on multiple cells
=IF(COUNTA(A6,C6,E6)=0,"",AVERAGE(A6,C6,E6))
Bob Umlas Excel MVP "WAR" wrote in message ... 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!
|
|
#4
November 20th, 2009, 03:27 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Condition based on multiple cells
=if(and(a6="",c6="",e6=""),"",average(a6:c6)
-- If this helps, please remember to click yes. "WAR" wrote: 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!
|
|
#5
November 20th, 2009, 04:04 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Condition based on multiple cells
Thanks, Paul for your timely answer . . . back to work!
"Paul C" wrote: =if(and(a6="",c6="",e6=""),"",average(a6:c6) -- If this helps, please remember to click yes. "WAR" wrote: 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 | |
| Display Modes | |
|
|
Linear Mode
