## General discussion

Thread display: Collapse - |

## All Comments

## Start or search

### Create a new discussion

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

## Sum Function in Excel 2000

Data: Cell J5 contains the formula 6*530/2000

Cell J6 contains the formula 100*556/2000

Absolute value of J5 is 1.59 cell is formated to display 2

Absolute value of J6 is 27.8 cell is formated to display 28

Absolute value of J32 is 29.39. I want excel to sum the displayed values not the absolute value.