Make calculations cope with null values

[oliviar]

Hi Guys,
I have some nested IIF statements, which work great, as long as the columns they reference have values in them. Otherwise, my database is littered with ERROR! all over it, and I get warnings when I export my data.

How can I make my IIF statements cope with nulls in columns they are trying to add?

 

[jeffreybrown]

What version of Excel are you using?

In 2007 you can use =IFERROR(value,value_if_error)

Lower versions =ISNA(value)

 

[oliviar]

Excellent. That will totally work. Especially if I combine different functions together.

thanks

 

[jeffreybrown]

You're welcome oliviar...glad to have helped