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

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

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

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).

"DarnTootn" wrote:

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

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

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?


"bpeltzer" wrote:

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).

"DarnTootn" wrote:

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

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

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(C rew!$A$1:$G$25,MATCH(B23,Crew!$A$1:$A$25,),MATCH(" Rate",Crew!$A$1:$G$1,)))



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"DarnTootn" wrote in message
...
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?


"bpeltzer" wrote:

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).

"DarnTootn" wrote:

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

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

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


"Peo Sjoblom" wrote:

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(C rew!$A$1:$G$25,MATCH(B23,Crew!$A$1:$A$25,),MATCH(" Rate",Crew!$A$1:$G$1,)))



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"DarnTootn" wrote in message
...
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?


"bpeltzer" wrote:

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).

"DarnTootn" wrote:

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

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

That would only happen if the cell it returns the value from is either blank
or zero


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"DarnTootn" wrote in message
...
thank you... it worked for me except that when it runs it always brings up
a
0. not just when true


"Peo Sjoblom" wrote:

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(C rew!$A$1:$G$25,MATCH(B23,Crew!$A$1:$A$25,),MATCH(" Rate",Crew!$A$1:$G$1,)))



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"DarnTootn" wrote in message
...
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?


"bpeltzer" wrote:

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).

"DarnTootn" wrote:

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

 

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