calculating % when some columns are 0

T

Ted

hi all, i'm not much of a guru with Excel. how do i prevent the #DIV/0! when
a column i'm dividing by is a 0.

i'm using Excel to calculate the Delta %. i'm using a simple formula
(K-L)/K. a lot of rows have values but obviously if for example K9 is 0 i'm
going to get an error. any ideas?

TIA
Ted
 
N

Niek Otten

Hi Ted,

=IF(K1=0,"",(K1-L1)/K1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| hi all, i'm not much of a guru with Excel. how do i prevent the #DIV/0! when
| a column i'm dividing by is a 0.
|
| i'm using Excel to calculate the Delta %. i'm using a simple formula
| (K-L)/K. a lot of rows have values but obviously if for example K9 is 0 i'm
| going to get an error. any ideas?
|
| TIA
| Ted
|
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top