I am Getting #N/A

R

Rj

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top