Menu
Ask a question Report

How to add iferror to formula [Solved/Closed]

Talahjer - Jan 26, 2011 at 02:47 AM - Latest reply:  Talahjer
- Jan 26, 2011 at 05:29 AM
Office Software Ask a question Report
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.


See more 

5 replies

Best answer
Report Respond to rayh
rayh - Jan 26, 2011 at 05:12 AM
1
Thank you
if(isna(formula),"Error",formula)

Thank you, rayh 1

Something to say? Add comment

CCM has helped 1598 users this month

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
Report Respond to Talahjer
Talahjer - Jan 26, 2011 at 05:27 AM
0
Thank you
dear Rayh

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

Thank you
Report Respond to Talahjer
Talahjer - Jan 26, 2011 at 05:29 AM
0
Thank you
Dear Rayh

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

Thank you
Ask a question