I am trying to add this formula in a cell to get rid of a div/0 error but it
won't let me add it

=IF(L4=0,0,IF(L20=0,0,if(l4=0 and l20=0,0,(L4-L20)/L4)))

it doesn't like the statement if(l4=0 and l20=0,0 is there anyway to
easily get rid of div/0 error

thanks

Try one more IF
=IF(L4=0,0,IF(L20=0,0,if(l4=0,if( l20=0,0,(L4-L20)/L4),(L4-L20/L4))))


"Nigel" wrote:

I am trying to add this formula in a cell to get rid of a div/0 error but it
won't let me add it

=IF(L4=0,0,IF(L20=0,0,if(l4=0 and l20=0,0,(L4-L20)/L4)))

it doesn't like the statement if(l4=0 and l20=0,0 is there anyway to
easily get rid of div/0 error

thanks

I did some investigation and maybe found a better way

=IF(ISERROR(IF(L4-L201,L4-L20,IF(L4-L20<-1,L4-L20,""))),"",IF(L4-L201,L4-L20,IF(L4-L20<-1,L4-L20,"")))


"Vacation's Over" wrote:

Try one more IF
=IF(L4=0,0,IF(L20=0,0,if(l4=0,if( l20=0,0,(L4-L20)/L4),(L4-L20/L4))))


"Nigel" wrote:

I am trying to add this formula in a cell to get rid of a div/0 error but it
won't let me add it

=IF(L4=0,0,IF(L20=0,0,if(l4=0 and l20=0,0,(L4-L20)/L4)))

it doesn't like the statement if(l4=0 and l20=0,0 is there anyway to
easily get rid of div/0 error

thanks

=if(L4<0,(L4-L20)/L4,0)

--
Regards,
Tom Ogilvy

"Nigel" wrote in message
...
I am trying to add this formula in a cell to get rid of a div/0 error but
it
won't let me add it

=IF(L4=0,0,IF(L20=0,0,if(l4=0 and l20=0,0,(L4-L20)/L4)))

it doesn't like the statement if(l4=0 and l20=0,0 is there anyway to
easily get rid of div/0 error

thanks

Tom,

I frequently use:
=If(L4,(L4-L20)/L4,0)

Is this just another alternative, or am I asking for trouble...

Thanks...

--
steveB

Remove "AYN" from email to respond
"Tom Ogilvy" wrote in message
...
=if(L4<0,(L4-L20)/L4,0)

--
Regards,
Tom Ogilvy

"Nigel" wrote in message
...
I am trying to add this formula in a cell to get rid of a div/0 error but
it
won't let me add it

=IF(L4=0,0,IF(L20=0,0,if(l4=0 and l20=0,0,(L4-L20)/L4)))

it doesn't like the statement if(l4=0 and l20=0,0 is there anyway to
easily get rid of div/0 error

thanks

six of one, half dozen of another. If someone else has to use the sheet,
mine method is clearer in my opinion (but every one has one).

--
Regards,
Tom Ogilvy

"STEVE BELL" wrote in message
news:d_LIe.24$vD.18@trnddc05...
Tom,

I frequently use:
=If(L4,(L4-L20)/L4,0)

Is this just another alternative, or am I asking for trouble...

Thanks...

--
steveB

Remove "AYN" from email to respond
"Tom Ogilvy" wrote in message
...
=if(L4<0,(L4-L20)/L4,0)

--
Regards,
Tom Ogilvy

"Nigel" wrote in message
...
I am trying to add this formula in a cell to get rid of a div/0 error
but
it
won't let me add it

=IF(L4=0,0,IF(L20=0,0,if(l4=0 and l20=0,0,(L4-L20)/L4)))

it doesn't like the statement if(l4=0 and l20=0,0 is there anyway to
easily get rid of div/0 error

thanks

Tom,

Thanks!

Just wanted to make sure I wasn't setting myself up...

--
steveB

Remove "AYN" from email to respond
"Tom Ogilvy" wrote in message
...
six of one, half dozen of another. If someone else has to use the sheet,
mine method is clearer in my opinion (but every one has one).

--
Regards,
Tom Ogilvy

"STEVE BELL" wrote in message
news:d_LIe.24$vD.18@trnddc05...
Tom,

I frequently use:
=If(L4,(L4-L20)/L4,0)

Is this just another alternative, or am I asking for trouble...

Thanks...

--
steveB

Remove "AYN" from email to respond
"Tom Ogilvy" wrote in message
...
=if(L4<0,(L4-L20)/L4,0)

--
Regards,
Tom Ogilvy

"Nigel" wrote in message
...
I am trying to add this formula in a cell to get rid of a div/0 error
but
it
won't let me add it

=IF(L4=0,0,IF(L20=0,0,if(l4=0 and l20=0,0,(L4-L20)/L4)))

it doesn't like the statement if(l4=0 and l20=0,0 is there anyway
to
easily get rid of div/0 error

thanks