Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
not calculating zero
I'm working on a 1600 line speadsheet, and I need to calculate the low price
in 6 of the columns. Then I need to take the low number of those 6 columns and multiply that low bid by another column. For one, how would that formula look, and for two, and my biggest problem, is how do I make it not calculate several of the cells in the 6 columns that are zero? I need it to ignore all the zero cells in the 6 columns. Thanks for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
not calculating zero
Try..Change the range accordingly
=SMALL(E8:G9,COUNTIF(E8:G9,0)+1) If this post helps click Yes --------------- Jacob Skaria "Excel Wizard.... NOT!" wrote: I'm working on a 1600 line speadsheet, and I need to calculate the low price in 6 of the columns. Then I need to take the low number of those 6 columns and multiply that low bid by another column. For one, how would that formula look, and for two, and my biggest problem, is how do I make it not calculate several of the cells in the 6 columns that are zero? I need it to ignore all the zero cells in the 6 columns. Thanks for your help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
not calculating zero
That looks like it works! Another rookie question, how do I add the
mulitplication on thte end of that? Thanks! "Jacob Skaria" wrote: Try..Change the range accordingly =SMALL(E8:G9,COUNTIF(E8:G9,0)+1) If this post helps click Yes --------------- Jacob Skaria "Excel Wizard.... NOT!" wrote: I'm working on a 1600 line speadsheet, and I need to calculate the low price in 6 of the columns. Then I need to take the low number of those 6 columns and multiply that low bid by another column. For one, how would that formula look, and for two, and my biggest problem, is how do I make it not calculate several of the cells in the 6 columns that are zero? I need it to ignore all the zero cells in the 6 columns. Thanks for your help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
not calculating zero
You mean =SMALL(E8:G9,COUNTIF(E8:G9,0)+1)*10
If this post helps click Yes --------------- Jacob Skaria "Excel Wizard.... NOT!" wrote: That looks like it works! Another rookie question, how do I add the mulitplication on thte end of that? Thanks! "Jacob Skaria" wrote: Try..Change the range accordingly =SMALL(E8:G9,COUNTIF(E8:G9,0)+1) If this post helps click Yes --------------- Jacob Skaria "Excel Wizard.... NOT!" wrote: I'm working on a 1600 line speadsheet, and I need to calculate the low price in 6 of the columns. Then I need to take the low number of those 6 columns and multiply that low bid by another column. For one, how would that formula look, and for two, and my biggest problem, is how do I make it not calculate several of the cells in the 6 columns that are zero? I need it to ignore all the zero cells in the 6 columns. Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating | Excel Discussion (Misc queries) | |||
Calculating Help | Excel Discussion (Misc queries) | |||
calculating | Excel Discussion (Misc queries) | |||
Calculating Age | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions |