| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding if error to a formula
Hello, I'm currently using this formula, which works perfectly :
=INDEX(Calls_Received_All!D:D,MATCH(1,(Calls_Recei ved_All!B1:B10000=D2)*(Calls_Received_All!C1:C1000 0=D1),0)) I know to enter ctrl-shift-enter. However if I have not entered data yet for one of the fields the formula is referring to I get: #N/A. I would like the cell to be blank if the reference cells are blank. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error adding up times in HH:MM format | Excel Discussion (Misc queries) | |||
| Adding individual error bars | Charts and Charting in Excel | |||
| Sum error when adding 31 days | Excel Discussion (Misc queries) | |||
| Error message when adding a name | Charts and Charting in Excel | |||
| #VALUE! error adding cells | Excel Discussion (Misc queries) | |||
Threaded Mode
