Don't display "#N/A" or "#VALUE!" in cell?

[Eric Livesay]

Hello fellas,

I have 2 different formulas in 2 different cells that returns "N/A" or "#VALUE!" if there is no data in the cell it's referenceing.

How can i keep the cell from displaying "N/A" or "#VALUE!"?

These are my formulas:
=AV277+LOOKUP(AW277,{"Fail","Pass"}, {10,100})

=IF(M343<>"",SUM(M343+180),"")

Do i have to nest an "ISNA" or "IF" formula in with it? If so, how?


Thanks in advance!

 

[barry houdini]

Which version of Excel are you using? In Excel 2007 and later you can use IFERROR function, e.g.

=IFERROR(formula,"")

so for the first formula that would be

=IFERROR(AV277+LOOKUP(AW277,{"Fail","Pass"}, {10,100}),"")

 

[Eric Livesay]

I'm using 2007 and your fix works great.

Thanks!

What about the other formula?
=IF(M343<>"",SUM(M343+180),"")

Inserting IFERROR doesn't work.