=IF(ISERROR) not returning my 'custom' text

[PDBartlett]

Hello

Could someone explain why this function is returning 'NA' and not a dash:

=IF(ISERROR(MASTER!E72),"-",MASTER!E72)

Master E72 is currently set to show an error so I can test this function, so surely the IF statement should return a dash?


Thanks

[romperstomper]

'NA' is not an error. #N/A is. Which one does your cell contain?

[akhileshgs]

there is one simple formula

=iferror()  

check that

[PDBartlett]

Cell MASTER E72 currently shows 'NA' because I've made a number divide by 'hello' (just to test)

This makes my if iserror statement return 'NA' and not #N/A but if there is any error at all I would like it to return a dash

[akhileshgs]

Just try with

=IFERROR(MASTER!E72,"-")  

[PDBartlett]

That still shows NA? :/

[PDBartlett]

I found the problem, MASTER E72 is another error formula which returns NA, I'll have to change that to a dash so I can get my error statement above to work, thanks guys.

[Saarang84]

Please Login or Register  to view this content.

As you have already said, Master!E72 is currently set to show an error, that cell already contains #N/A (the error value or NA). So, when either IF(ISERROR(..) is used or IFERROR(...) is used, it'll return the error value which is displayed as NA as there is no valid data.

Link: http://office.microsoft.com/en-in/ex...r_na_in_place_