Excel - Is Error Formula

[elfa]

Hello,

I have the following formula =IF(M40-$J40>0,M40-$J40,"")

I was wondering how to type this so the iserror function is inserted.

I tried =if(iserror(M40-$J40>0,M40-$J40,""),"",M40-$J40>0,M40-$J40) but it did not work.

The reason I am asking is because I have to drag the fomula to the right and eventually it returns #value.

Thanks
Elfa.

 

[AnotherHiggins]

It goes like this:
[COLOR=blue white]=if(iserror(your formula),"",your formula)[/color]

[tt]_____
[blue]-John[/blue]
[/tt][red]"If you're flammable and have legs, you are never blocking a fire exit."[/red]
-Mitch Hedberg

Help us help you. Please read FAQ181-2886 before posting.