IfError Help

K

Khanjohn

This is what I posted a day ago and was told to use IfError. I assume I out
it in the H column but I have it already doing =F3+G3 and in G3 I am using
=if(E35=B$6,
$AA$2,"")

I currently need help on a project m tryin got complete. I have 2 codes
that gather data for me. one matches the column and other matches the row
and then gives em the data in the column. I have this going to a group of
cells we can call F3 thru F8. This part works fine. I have used =if(E35=B$6,
$AA$2,"") to match and place a 1 so that it can be added to my formula. If
it matches it works great. However, Where it searches G35 doesnt match in F3
say thru F7 but matches F8 I get N/A and then the numbers will not be
displayed. How do I get it to place a zero in the cell if it doesnt match to
the formula works. Her is example.
E F G H E35 = RFL B6 = RFL AA2
1
3 CHA 8 0 8
4 DEX 8 0 8
5 WIL 8 0 8
6 INT 8 0 8
7 RFL 8 1 9
8 DRV 8 0 8
9 ONI 8 0 8
10 PAR 8 0 8

Now when I copy it to different Cells to make it seach for and of E i get
this:

E F G H E35 = RFL B6 =
RFL AA2 1
3 CHA 8 N/A ###
4 DEX 8 N/A ###
5 WIL 8 N/A ###
6 INT 8 N/A ###
7 RFL 8 1 9
8 DRV 8 N/A ###
9 ONI 8 N/A ###
10 PAR 8 N/A ### B6 can only match one fo the items E3:E10.

I need it to take out the N/A and leave a zero or blank so that the formula
is completes as the column H3:H10 is copied somewhere else.

QUESTION is where and how do I put in IfError. Thanks
 
P

Plum

Basically, the format of the ifiserror formula should be
=If(iserror(FORMULA),0,(FORMULA)) ie. if the formula returns an error, show a
zero (or whatever - you might prefer "") otherwise, show me the formula.

For example, if you formula was =A1+A2, then you would apply iserror like
this:
=IF(ISERROR(A1+A2),0,A1+A2)

Hope that makes sense.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Needing Help 3
Move cells down to match cells 0
Move cells down to match cells 0
Move cells down to match cells 3
Move to match cells 0
Move to match cells 0
Move to match cells 0
Move to match cells 0

Top