software

I am trying us the =IF function with the following... =INDEX(Crew!$A$1:$G$25,
MATCH(B23,Crew!$A$1:$A$25,), MATCH(quot;Ratequot;,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).

quot;DarnTootnquot; wrote:

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

I have tried that with the quot;myformulaquot; 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?quot;bpeltzerquot; wrote:

gt; You didn't indicate the entire formula you've tried, but the general format
gt; would be =if(isna(myformula),0,myformula)
gt; There's no comma following the ISNA; myformula is an argument of that
gt; function. Also be sure that your parentheses are balanced (three left
gt; parens require three right parens).
gt;
gt; quot;DarnTootnquot; wrote:
gt;
gt; gt; I am trying us the =IF function with the following... =INDEX(Crew!$A$1:$G$25,
gt; gt; MATCH(B23,Crew!$A$1:$A$25,), MATCH(quot;Ratequot;,Crew!$A$1:$G$1,))
gt; gt; But I get an error message... How would I do this so it will give a 0 in
gt; gt; this cell??? I also am using this IF function in another cell with out an
gt; gt; additional function like INDEX... Can I use two different functions like this
gt; gt; 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(quot;Ratequot;,Crew!$A$1:$G$1,))),0,INDEX(C rew!$A$1:$G$25,MATCH(B23,Crew!$A$1:$A$25,),MATCH(quot; Ratequot;,Crew!$A$1:$G$1,)))
--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;DarnTootnquot; gt; wrote in message
...
gt;I have tried that with the quot;myformulaquot; inserted in the correct places with
gt; the correct paretheses... but I get an error... I guess I can't insert
gt; the
gt; =INDEX function inside the =IF(ISNA.... can I?
gt;
gt;
gt; quot;bpeltzerquot; wrote:
gt;
gt;gt; You didn't indicate the entire formula you've tried, but the general
gt;gt; format
gt;gt; would be =if(isna(myformula),0,myformula)
gt;gt; There's no comma following the ISNA; myformula is an argument of that
gt;gt; function. Also be sure that your parentheses are balanced (three left
gt;gt; parens require three right parens).
gt;gt;
gt;gt; quot;DarnTootnquot; wrote:
gt;gt;
gt;gt; gt; I am trying us the =IF function with the following...
gt;gt; gt; =INDEX(Crew!$A$1:$G$25,
gt;gt; gt; MATCH(B23,Crew!$A$1:$A$25,), MATCH(quot;Ratequot;,Crew!$A$1:$G$1,))
gt;gt; gt; But I get an error message... How would I do this so it will give a 0
gt;gt; gt; in
gt;gt; gt; this cell??? I also am using this IF function in another cell with out
gt;gt; gt; an
gt;gt; gt; additional function like INDEX... Can I use two different functions
gt;gt; gt; like this
gt;gt; gt; 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 truequot;Peo Sjoblomquot; wrote:

gt; You must have applied it incorrectly, try this
gt;
gt; =IF(ISNA(INDEX(Crew!$A$1:$G$25,MATCH(B23,Crew!$A$1 :$A$25,),MATCH(quot;Ratequot;,Crew!$A$1:$G$1,))),0,INDEX(C rew!$A$1:$G$25,MATCH(B23,Crew!$A$1:$A$25,),MATCH(quot; Ratequot;,Crew!$A$1:$G$1,)))
gt;
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;DarnTootnquot; gt; wrote in message
gt; ...
gt; gt;I have tried that with the quot;myformulaquot; inserted in the correct places with
gt; gt; the correct paretheses... but I get an error... I guess I can't insert
gt; gt; the
gt; gt; =INDEX function inside the =IF(ISNA.... can I?
gt; gt;
gt; gt;
gt; gt; quot;bpeltzerquot; wrote:
gt; gt;
gt; gt;gt; You didn't indicate the entire formula you've tried, but the general
gt; gt;gt; format
gt; gt;gt; would be =if(isna(myformula),0,myformula)
gt; gt;gt; There's no comma following the ISNA; myformula is an argument of that
gt; gt;gt; function. Also be sure that your parentheses are balanced (three left
gt; gt;gt; parens require three right parens).
gt; gt;gt;
gt; gt;gt; quot;DarnTootnquot; wrote:
gt; gt;gt;
gt; gt;gt; gt; I am trying us the =IF function with the following...
gt; gt;gt; gt; =INDEX(Crew!$A$1:$G$25,
gt; gt;gt; gt; MATCH(B23,Crew!$A$1:$A$25,), MATCH(quot;Ratequot;,Crew!$A$1:$G$1,))
gt; gt;gt; gt; But I get an error message... How would I do this so it will give a 0
gt; gt;gt; gt; in
gt; gt;gt; gt; this cell??? I also am using this IF function in another cell with out
gt; gt;gt; gt; an
gt; gt;gt; gt; additional function like INDEX... Can I use two different functions
gt; gt;gt; gt; like this
gt; gt;gt; gt; together?? if so How... PLZ HELP.. THANKS
gt;
gt;
gt;

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

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;DarnTootnquot; gt; wrote in message
...
gt; thank you... it worked for me except that when it runs it always brings up
gt; a
gt; 0. not just when true
gt;
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; You must have applied it incorrectly, try this
gt;gt;
gt;gt; =IF(ISNA(INDEX(Crew!$A$1:$G$25,MATCH(B23,Crew!$A$1 :$A$25,),MATCH(quot;Ratequot;,Crew!$A$1:$G$1,))),0,INDEX(C rew!$A$1:$G$25,MATCH(B23,Crew!$A$1:$A$25,),MATCH(quot; Ratequot;,Crew!$A$1:$G$1,)))
gt;gt;
gt;gt;
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; nwexcelsolutions.com
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;DarnTootnquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have tried that with the quot;myformulaquot; inserted in the correct places
gt;gt; gt;with
gt;gt; gt; the correct paretheses... but I get an error... I guess I can't insert
gt;gt; gt; the
gt;gt; gt; =INDEX function inside the =IF(ISNA.... can I?
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;bpeltzerquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; You didn't indicate the entire formula you've tried, but the general
gt;gt; gt;gt; format
gt;gt; gt;gt; would be =if(isna(myformula),0,myformula)
gt;gt; gt;gt; There's no comma following the ISNA; myformula is an argument of that
gt;gt; gt;gt; function. Also be sure that your parentheses are balanced (three
gt;gt; gt;gt; left
gt;gt; gt;gt; parens require three right parens).
gt;gt; gt;gt;
gt;gt; gt;gt; quot;DarnTootnquot; wrote:
gt;gt; gt;gt;
gt;gt; gt;gt; gt; I am trying us the =IF function with the following...
gt;gt; gt;gt; gt; =INDEX(Crew!$A$1:$G$25,
gt;gt; gt;gt; gt; MATCH(B23,Crew!$A$1:$A$25,), MATCH(quot;Ratequot;,Crew!$A$1:$G$1,))
gt;gt; gt;gt; gt; But I get an error message... How would I do this so it will give a
gt;gt; gt;gt; gt; 0
gt;gt; gt;gt; gt; in
gt;gt; gt;gt; gt; this cell??? I also am using this IF function in another cell with
gt;gt; gt;gt; gt; out
gt;gt; gt;gt; gt; an
gt;gt; gt;gt; gt; additional function like INDEX... Can I use two different functions
gt;gt; gt;gt; gt; like this
gt;gt; gt;gt; gt; together?? if so How... PLZ HELP.. THANKS
gt;gt;
gt;gt;
gt;gt;
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 quot;LOGOquot; 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(quot;LOGOquot;,Crew!$A$1:$G$1,))

I can bring up the correct cell but it is blank