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
|