Adding if error to a formula
getting the same error. Still ctrl-shift-enter, right?
"Dave Peterson" wrote:
How did it not work?
It looks like it should.
Jim wrote:
That did not work. Any other suggestions. Oh, and thanks for helping me.
"Roger Govier" wrote:
Hi Jim
One way
=IF(COUNTA(D1:D2)<2,"",your_formula)
--
Regards
Roger Govier
"Jim" wrote in message
...
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
--
Dave Peterson
|