getting #DIV/0! when calculating percentage
 

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

getting #DIV/0! when calculating percentage
 

Hi Ted,
Try this formula:
=IF(ISNA((K-L)/K),"",(K-L)/K)
Regards - Dave

"Ted" wrote:

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

getting #DIV/0! when calculating percentage
 

thanks for the response Dave. unfortunately that didn't work. i was thinking
about something like that but i don't know the function in Excel.

"Dave" wrote in message
...
Hi Ted,
Try this formula:
=IF(ISNA((K-L)/K),"",(K-L)/K)
Regards - Dave

"Ted" wrote:

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

getting #DIV/0! when calculating percentage
 

you did however point me in the right direction. i simplified it to
=IF(K=0,"",(K-L)/K) and that did work. in access its iif not if...thats what
was throwing me off. thanks for your help.

"Dave" wrote in message
...
Hi Ted,
Try this formula:
=IF(ISNA((K-L)/K),"",(K-L)/K)
Regards - Dave

"Ted" wrote:

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

getting #DIV/0! when calculating percentage
 

Should be =IF(ISERROR((K-L)/K),"",(K-L)/K)


"Dave" wrote:

Hi Ted,
Try this formula:
=IF(ISNA((K-L)/K),"",(K-L)/K)
Regards - Dave

"Ted" wrote:

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