iif Error... 1

[shepkrm]

Hello,

I am trying to create an if expression to display a zero if a previous calculation returned #error.

here's what i have:

allocation:iif([calc]="error#",0,[calc])

both calc and allocation are returning #error.

any ideas?

thanks!
becky

 

[PHV]

I'd correct calc ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[pbrodsky]

how about iif(iserror([calc],0,[calc])

 

[pbrodsky]

oops:

iif(iserror([calc]),0,[calc])

 

[shepkrm]

thanks, pbrodsky!

sometimes the easiest answers are the hardest to figure out...