Simple Formula Help!

[asjmoron]

Hey guys,

I have column with 500 repeated formulas.

The formula is

=IFERROR(IF('052'!E44="","",'052'!E44),"")

BUT....the E44 is different on each line with no sequential order. I need to remove the "IFERROR(" and ,"") from every line without effecting the IF formula criteria.

any help?!

 

[asjmoron]

Having said that....its having a hard time replacing ' with =

 

[gaz_chops]

Wouldn't go that far, but you're welcome.

 

[gaz_chops]

Use a dif symbol, like §