ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I am Getting #N/A (https://www.excelbanter.com/excel-worksheet-functions/8366-i-am-getting-n.html)

Rj

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



All times are GMT +1. The time now is 07:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com