| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula text attn:Jacob
Jacob
Thanks again for the help, I am fairly new at the formula bit. I have another woork sheet with the same issue, it is an amount divided by the number of days to give an average. =sum(c45/d45) the same issue shows in the uncalculated cell. unlike my other work sheet the c column is not a static number. what in a formula leaves the uncalculated cell empty before any entrys? 6730 10 673 15205 30 507 #DIV/0! Thanks -- Max |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula text attn:Jacob
Try the below. Count() counts the number of numbers in the range. Here if it
is 2 only we are doing the division or else blank =IF(COUNT(c45,d45)=2,c45/d45,"") If this post helps click Yes --------------- Jacob Skaria "mexmex" wrote: Jacob Thanks again for the help, I am fairly new at the formula bit. I have another woork sheet with the same issue, it is an amount divided by the number of days to give an average. =sum(c45/d45) the same issue shows in the uncalculated cell. unlike my other work sheet the c column is not a static number. what in a formula leaves the uncalculated cell empty before any entrys? 6730 10 673 15205 30 507 #DIV/0! Thanks -- Max |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula text attn:Jacob
Jacob
I think I may have mislead you with my insert, I am doing a divison calculation not a count one. The first column would be say the number of units divided by the number of days to get an average number in the third column without having that other formula in that cell before I enter any values. Thanks sorry about the confusion. -- Max "Jacob Skaria" wrote: Try the below. Count() counts the number of numbers in the range. Here if it is 2 only we are doing the division or else blank =IF(COUNT(c45,d45)=2,c45/d45,"") If this post helps click Yes --------------- Jacob Skaria "mexmex" wrote: Jacob Thanks again for the help, I am fairly new at the formula bit. I have another woork sheet with the same issue, it is an amount divided by the number of days to give an average. =sum(c45/d45) the same issue shows in the uncalculated cell. unlike my other work sheet the c column is not a static number. what in a formula leaves the uncalculated cell empty before any entrys? 6730 10 673 15205 30 507 #DIV/0! Thanks -- Max |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula text attn:Jacob
The formula I posted does the division only...but before doing that it checks
whether both the numbers are available.. If this post helps click Yes --------------- Jacob Skaria "mexmex" wrote: Jacob I think I may have mislead you with my insert, I am doing a divison calculation not a count one. The first column would be say the number of units divided by the number of days to get an average number in the third column without having that other formula in that cell before I enter any values. Thanks sorry about the confusion. -- Max "Jacob Skaria" wrote: Try the below. Count() counts the number of numbers in the range. Here if it is 2 only we are doing the division or else blank =IF(COUNT(c45,d45)=2,c45/d45,"") If this post helps click Yes --------------- Jacob Skaria "mexmex" wrote: Jacob Thanks again for the help, I am fairly new at the formula bit. I have another woork sheet with the same issue, it is an amount divided by the number of days to give an average. =sum(c45/d45) the same issue shows in the uncalculated cell. unlike my other work sheet the c column is not a static number. what in a formula leaves the uncalculated cell empty before any entrys? 6730 10 673 15205 30 507 #DIV/0! Thanks -- Max |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula text attn:Jacob
Thanks Jacob the formula worked for the issue. Now all I have to do is
figure out how to get rid of the zeros that show up in the cell with the formula when their are no entries in the cells they refer too -- Max "Jacob Skaria" wrote: The formula I posted does the division only...but before doing that it checks whether both the numbers are available.. If this post helps click Yes --------------- Jacob Skaria "mexmex" wrote: Jacob I think I may have mislead you with my insert, I am doing a divison calculation not a count one. The first column would be say the number of units divided by the number of days to get an average number in the third column without having that other formula in that cell before I enter any values. Thanks sorry about the confusion. -- Max "Jacob Skaria" wrote: Try the below. Count() counts the number of numbers in the range. Here if it is 2 only we are doing the division or else blank =IF(COUNT(c45,d45)=2,c45/d45,"") If this post helps click Yes --------------- Jacob Skaria "mexmex" wrote: Jacob Thanks again for the help, I am fairly new at the formula bit. I have another woork sheet with the same issue, it is an amount divided by the number of days to give an average. =sum(c45/d45) the same issue shows in the uncalculated cell. unlike my other work sheet the c column is not a static number. what in a formula leaves the uncalculated cell empty before any entrys? 6730 10 673 15205 30 507 #DIV/0! Thanks -- Max |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula text attn:Jacob
Try
=IF(ISERROR(C45/D45),"",C45/D45) If this post helps click Yes --------------- Jacob Skaria "mexmex" wrote: Thanks Jacob the formula worked for the issue. Now all I have to do is figure out how to get rid of the zeros that show up in the cell with the formula when their are no entries in the cells they refer too -- Max "Jacob Skaria" wrote: The formula I posted does the division only...but before doing that it checks whether both the numbers are available.. If this post helps click Yes --------------- Jacob Skaria "mexmex" wrote: Jacob I think I may have mislead you with my insert, I am doing a divison calculation not a count one. The first column would be say the number of units divided by the number of days to get an average number in the third column without having that other formula in that cell before I enter any values. Thanks sorry about the confusion. -- Max "Jacob Skaria" wrote: Try the below. Count() counts the number of numbers in the range. Here if it is 2 only we are doing the division or else blank =IF(COUNT(c45,d45)=2,c45/d45,"") If this post helps click Yes --------------- Jacob Skaria "mexmex" wrote: Jacob Thanks again for the help, I am fairly new at the formula bit. I have another woork sheet with the same issue, it is an amount divided by the number of days to give an average. =sum(c45/d45) the same issue shows in the uncalculated cell. unlike my other work sheet the c column is not a static number. what in a formula leaves the uncalculated cell empty before any entrys? 6730 10 673 15205 30 507 #DIV/0! Thanks -- Max |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Previously helped by Jacob Skaria -- need more help | Excel Discussion (Misc queries) | |||
| Ping Jacob Skaria | Excel Worksheet Functions | |||
| Jacob & Co. Other Prices | Charts and Charting in Excel | |||
| Attn: Bob Phillips (or any expert!)... help with formula | Excel Worksheet Functions | |||
| Not all of the text is visible.... (Attn: Dave Peterson) | Excel Discussion (Misc queries) | |||
Linear Mode
