| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| click & drag not working | Excel Discussion (Misc queries) | |||
| amount of working days per month | Excel Discussion (Misc queries) | |||
| Calculation with Working day of the year | Excel Discussion (Misc queries) | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Working time and days | Excel Discussion (Misc queries) | |||
Threaded Mode
