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! |
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 |