Solved

# Excell 2000 - Cell calculations do not function correctly

Posted on 2001-08-10

I haven't the time to research this one, therefore I need help from the experts.

Creating a worksheet that calculates values both across as well as down. As an example:

| quantity | value | 1.15 | sum |

| quantity | value | 1.15 | sum |

| quantity | value | 1.15 | sum |

| quantity | value | 1.15 | sum |

| quantity | value | 1.15 | sum |

| | | |total|

The value of "sum" is cell 1*cell 2*cell 3

Initially sum calculates correctly, however if I change either the quantity of value figures, sum does not recalculate (or update).

What needs to be changed?

Dennis