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
|