Working with =IF(ISNA,(myformula),0,(myformula)

D

DarnTootn

I am trying us the =IF function with the following... =INDEX(Crew!$A$1:$G$25,
MATCH(B23,Crew!$A$1:$A$25,), MATCH("Rate",Crew!$A$1:$G$1,))
But I get an error message... How would I do this so it will give a 0 in
this cell??? I also am using this IF function in another cell with out an
additional function like INDEX... Can I use two different functions like this
together?? if so How... PLZ HELP.. THANKS
 
B

bpeltzer

You didn't indicate the entire formula you've tried, but the general format
would be =if(isna(myformula),0,myformula)
There's no comma following the ISNA; myformula is an argument of that
function. Also be sure that your parentheses are balanced (three left
parens require three right parens).
 
D

DarnTootn

I have tried that with the "myformula" inserted in the correct places with
the correct paretheses... but I get an error... I guess I can't insert the
=INDEX function inside the =IF(ISNA.... can I?
 
P

Peo Sjoblom

You must have applied it incorrectly, try this

=IF(ISNA(INDEX(Crew!$A$1:$G$25,MATCH(B23,Crew!$A$1:$A$25,),MATCH("Rate",Crew!$A$1:$G$1,))),0,INDEX(Crew!$A$1:$G$25,MATCH(B23,Crew!$A$1:$A$25,),MATCH("Rate",Crew!$A$1:$G$1,)))



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
D

DarnTootn

thank you... it worked for me except that when it runs it always brings up a
0. not just when true
 
D

DarnTootn

Thank you for your help.. I finally got it to work... I had a operand that
was misplaced in my original formula... I was wondering if you could help
with another problem...? using this formula where "LOGO" should be a .bmp
how do I attach a .bmp to a specfic cell in another sheet in the workbook?
=INDEX(Crew!$A$1:$G$25, MATCH(G12,Crew!$A$1:$A$25,),
MATCH("LOGO",Crew!$A$1:$G$1,))

I can bring up the correct cell but it is blank
 
Top