View Single Post
  #1   Report Post  
Rj
 
Posts: n/a
Default I am Getting #N/A

I am trying to subtract I6 from 2 and put it in G12 but I want it to = zero
until I tell it to subtract, right now if it is left blank it will give me
#N/A below is the formula that I am using.
='Client Info'!I6-2

Here is how I am getting I6
=INDEX(B316:B373, MATCH(B9,C316:C373,0))


Any help would be appericated