I have the following formula, that i need to remove a possibility of a divide by zero error
=IF(K9 <> 0, (K9-K8)/K8, 0)
The IF function was my attempt (so the only formula i need is (K9-K8)/K8), but it doesnt work for the first value in the column, this is where i get the #div/0! error (for example when k8 hasn't got a value)
any help greatly appreciated.
Bookmarks