"Vic Abrahamian" wrote in message
...
The problemis some columns in the same worksheet work and some dont'. Some
calculate and some don't update and don't work

Hi Vic,

Check the input cells for the formulas that don't update and make sure
they are not formatted as text. The Format Cells Number tab will have
the Text entry selected if this is the case.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

"Vic Abrahamian" wrote in message
...
The problemis some columns in the same worksheet work and some dont'. Some
calculate and some don't update and don't work

"Rob Bovey" wrote:

Hi Vic,

It sounds like you may not have your workbook set to calculate
automatically. If you're using Excel 2003 or earlier, choose Tools
Options
Calculation from the Excel menu. Make sure the Automatic option in the
upper left corner is selected, then click OK and save your workbook.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

"Vic Abrahamian" wrote in
message
...
Than you when I change the 1 to 100% it shows a 100% as the result,
but if I change cell A1 to $5 instead of $0
The result still stays 100%
It doesn't change to the real result

"Rob Bovey" wrote:

Hi Vic,

Here's one way:

=IF(A1=0,1,(A1-A2)/ABS(A1))

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

"Vic Abrahamian" wrote in
message
...
Hi,
When I use the following formula
=(a1-a2)/ABS(a1)
Any time A1=0, I receive a devide by 0 error.
How can I change the formula to show 100% instead?
Thank you