Hello.
I keep havng errors show up. I was wanting to change the error to a zero value.. since its messing up some other things on my sheet.
Below are examples of what i have that is causing errors. Is there any way to set it to 0 intead or " " ?
{=SMALL(IF(F42:AS42=0,"0",F42:AS42),1)} this works fine once i have a value in F42:AS42 but i want to get rid of #NUM error before i enter any values there
=INDEX($F$7:$AS$7,MATCH(AX147,$F$42:$AS$42,0))
guessing this one above gets an error because its pulling info from top one?
Even tried this..
=IF(ISERR(INDEX($AW$147:$AW$150,MATCH(AN148,$AX$147:$AX$150,0))),,INDEX($AW$147:$AW$150,MATCH(AN148,$AX$147:$AX$150,0)))
and still get a #NUM error
Well i'm getting the #NUM errors until the formula has a value then it works fine....
Any ideas? How to set these bad boys to 0 until value is attained for area..
Thanks so much
I keep havng errors show up. I was wanting to change the error to a zero value.. since its messing up some other things on my sheet.
Below are examples of what i have that is causing errors. Is there any way to set it to 0 intead or " " ?
{=SMALL(IF(F42:AS42=0,"0",F42:AS42),1)} this works fine once i have a value in F42:AS42 but i want to get rid of #NUM error before i enter any values there
=INDEX($F$7:$AS$7,MATCH(AX147,$F$42:$AS$42,0))
guessing this one above gets an error because its pulling info from top one?
Even tried this..
=IF(ISERR(INDEX($AW$147:$AW$150,MATCH(AN148,$AX$147:$AX$150,0))),,INDEX($AW$147:$AW$150,MATCH(AN148,$AX$147:$AX$150,0)))
and still get a #NUM error
Well i'm getting the #NUM errors until the formula has a value then it works fine....
Any ideas? How to set these bad boys to 0 until value is attained for area..
Thanks so much
Last edited:
