Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to do calculations with Null in the column?
As showed in the example:
Row No. A B C Calculations 1 5 #N/A #N/A 2 10 3 20------------(A4-A2) 3 20 #N/A #N/A 4 30 6 25------------(A7-A2)/2 5 40 #N/A #N/A 6 50 #N/A #N/A 7 60 8 25-----------(A9-A4)/2 8 70 #N/A 9 80 14 20-----------(A9-A7) 10 90 #N/A 11 100 #N/A Whether we do the calculations depends on the status of cells in the column B. If the cell in the column B is denoted as #N/A, there's no calculation at all. If the value in column B is a number, then we do some calculations with cells in the column A and display the results in the column C. The way to calculate is half the distance between cells in column A on either side. But on upper or lower edge, it's simply the difference between the edge cell and its adjacent cell. It's too difficult to explain this. Please see the calculations above. Thanks for the patience. Please help me solve this problem. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I pick up only the rows with a non-null key column on a separate sheet? | Excel Worksheet Functions | |||
How do I Excel countif column a =? and column b = null ? | Excel Worksheet Functions | |||
end of column refence in several calculations | Excel Discussion (Misc queries) | |||
formula to sum all sum calculations in a column | Excel Worksheet Functions | |||
Average Column, but Skip Null and 0? | Excel Worksheet Functions |