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

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

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

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

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