How to add iferror to formula [Solved/Closed]

Question

How to add iferror to formula [Solved/Closed]

Report

Talahjer - Jan 26, 2011 at 02:47 AM
Talahjer - Jan 26, 2011 at 05:29 AM

Dear all

i have an excel database which search for a word in a cell and if it finds it, it puts it in another cell. The problem is the sell contains #N/A until it finds a word to be replaced. I was wondering if there is a possibility to add iferror to the formula in order to show the cell empty inested of showing #N/A?

i am really looking for your support and help as this is the best site to place a question

Thank you in advance.

How to add iferror to formula
Add/subtract & vlookup formula ✓ - Forum - Office Software
Add formula bar in excel - How-To - Excel
Excel formula to add rows based on cell value - Forum - Excel
Excel formula to add days to a date - How-To - Excel
Add two formulas in one cell - How-To - Excel

3 replies

Answer 2 / 3

Talahjer
Jan 26, 2011 at 05:27 AM

dear Rayh

iapplied your formula and it was resolved. You are the best

Thank you

Answer 3 / 3

Talahjer
Jan 26, 2011 at 05:29 AM

Dear Rayh

I applied your formula and it was resolved. You are the best

Thank you

Ask a question

rayh · Accepted Answer · 2011-01-26T05:12:44-0500

Answer 1 / 3

rayh
Jan 26, 2011 at 05:12 AM

if(isna(formula),"Error",formula)

Report

Talahjer
Jan 26, 2011 at 05:22 AM

dear Rayh

i am sorry for bothering you but I tried to addmy formula whic is
=LOOKUP(2^15,SEARCH(GoverAndDist!A$1:T$1,H4855),GoverAndDist!A$1:T$1)
to the one you gave me but honesly I could not.
if you do not mind, plese combine both formulas

thanks in advance

Report

Talahjer
Jan 26, 2011 at 05:29 AM

Dear Rayh

I applied your formula and it was resolved. You are the best

Thank you

How to add iferror to formula [Solved/Closed]

3 replies

Your reply

Subscribe To Our Newsletter!