Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Function question (probably easy)
I'm working with four columns. the cells in my 4th column are going to be the
averages of the other three columns. If I copy my average formulay down the whole column then everything is fine except it displays "#DIV/0!" becuase I dont' have any information in the fields yet. How can I tell that cell to display nothing if atleast one of the other three cells don't have any values. If this doesn't make sense please let me know I'll try again. Thanks in advance. Travis |
#2
|
|||
|
|||
Is this even possible. Please let me know.
"Dahlman" wrote: I'm working with four columns. the cells in my 4th column are going to be the averages of the other three columns. If I copy my average formulay down the whole column then everything is fine except it displays "#DIV/0!" becuase I dont' have any information in the fields yet. How can I tell that cell to display nothing if atleast one of the other three cells don't have any values. If this doesn't make sense please let me know I'll try again. Thanks in advance. Travis |
#3
|
|||
|
|||
Try using:
=IF(OR(A1="",B1="",C1=""),"",SUM(A1:C1)/3) "Dahlman" wrote: I'm working with four columns. the cells in my 4th column are going to be the averages of the other three columns. If I copy my average formulay down the whole column then everything is fine except it displays "#DIV/0!" becuase I dont' have any information in the fields yet. How can I tell that cell to display nothing if atleast one of the other three cells don't have any values. If this doesn't make sense please let me know I'll try again. Thanks in advance. Travis |
#4
|
|||
|
|||
Here is one to try:
=IF(COUNT(A1:C1)=3,AVERAGE(A1:C3),''") best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dahlman" wrote in message ... I'm working with four columns. the cells in my 4th column are going to be the averages of the other three columns. If I copy my average formulay down the whole column then everything is fine except it displays "#DIV/0!" becuase I dont' have any information in the fields yet. How can I tell that cell to display nothing if atleast one of the other three cells don't have any values. If this doesn't make sense please let me know I'll try again. Thanks in advance. Travis |
#5
|
|||
|
|||
Thanks you very much. I had to change the =3 to 0 because I wanted it to
average even if there was only one entry but you gave me a great start. Thanks. "Bernard Liengme" wrote: Here is one to try: =IF(COUNT(A1:C1)=3,AVERAGE(A1:C3),''") best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dahlman" wrote in message ... I'm working with four columns. the cells in my 4th column are going to be the averages of the other three columns. If I copy my average formulay down the whole column then everything is fine except it displays "#DIV/0!" becuase I dont' have any information in the fields yet. How can I tell that cell to display nothing if atleast one of the other three cells don't have any values. If this doesn't make sense please let me know I'll try again. Thanks in advance. Travis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy function question | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Grading Function Question... | Excel Worksheet Functions | |||
Grading Function Question... | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |