This works ...... Thank you !!!

"Toppers" wrote:

Something like:

=IF(A1=0,B1,(B1-A1)/A1)

Where A1= original Value
B1=new Value



"Leland7" wrote:

I am doing comparison figures to determine percent of change. Some figures
compare for example 4 to 0 and instead of getting an increase of 400%, get
#DIV/0! .... anyone know a formula that would give me the right percent?